I would like to get the value of a field from a related set of records.

The value would be from a whichever record has a second field (date) which is the most recent.

Wow - hope that made sense!!

eg

record1 - field1=35, field2=2nov2002

record2 - field1=12,field2=2jan2007

result=12 as field2 has the latest date

thanks

Hi

Why dont you sort with date field? and the date latest date will be on top...

Yes, sort the relationship by date desc, and the parent will see the child with the most recent date as its first related record.

Thanks for you good suggestions. So i dont get thrown by a resort I found an alternate method.

I created a new field Max(datefield) and then created a new relationship using this max field to have access to the relevant fields.

That'll work too. I usually have a dedicated relationship for such a sort to_TO_Sorted