getting a particular value from a set of related records

[Aussie John]

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

[Tusif Ahmad]

Hi

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

[bcooney]

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

[Aussie John]

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.

[bcooney]

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