How to pull most recent record for relationship?

[Erin learningasigo]

I have some fields in a layout in my "A" database that are actually from database "B." The relationship is based on ID. There are multiple records for some IDs in database "B", so sometimes I get the older data pulled from database "B." But actually, I always want it to pull the most recent record for any given ID in database "B." Does that make sense? Anyone know?

[tgilders]

I think the Last function is what you're looking for. It will give you the last related record through the relationship (which would be the most recently created record).

[fabriceN]

Be careful with Last(), because it returns the last not empty value, as opposed to a sorted relationship.

It's usually ok, but it's something to know.

[comment]

See also:

http://www.fmforums.com/forum/showtopic.php?tid/194879/post/288690/#288690

[Erin learningasigo]

Thank you! Where do I put/use the "Last" function?

[Erin learningasigo]

Can anyone out there reply to my "how to" question above? Thanks!