Skip to Content
0
Former Member
Jul 22, 2008 at 09:15 AM

Link tables based on a date

38 Views

I'm trying to link 2 tables A and B together.

For every entry in A there is either 0, 1 or many entries in B.

What I am trying to do is find whichever entry in B has the earliest date in it.

eg

A

---

PKid

1

B

---

FKid | date

1 | 01/01/2005

1 | 12/12/2006

1 | 31/12/2007

So in this instance I only want the data from the first row, with the date 01/01/2005.

Is this possible in CR XI?