Hi  I've a table with a date field and records

 

1/11/12

1/11/12

2/11/12

7/11/12

7/11/12

7/11/12

7/11/12

12/11/12

....

 

and have been trying to work out a self join relationship where the record set would be

 

1/11/12

2/11/12

7/11/12

12/11/12

....

 

anyone help ?

thanks

Cate

 

The simplest way to show only the first record of a group, IMHO, would be to sort the records and show them in a list layout that contains a leading sub-summary by Date part, and no body part.

 

 

Doing this through a relationship is more complicated (do a find for "Ugo method").

Michael: I tried to do the find you mentioned but it didn't work, I think the find function here is not working very well on old posts.

 

Googling "UGO method" however, I did find a link to your 28 April 2005 post. But that link within your post (the second link) now appears to be dead.

 

http://fmforums.com/forum/topic/33282-unique-records-in-portal/?p=154431

 

Posted 28 April 2005 - 05:17 AM

 

See Ugo's method here.
http://www.fmforums.com/forum/showtopic.php?tid/153197 

 

Try this link

thanks