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?