Calculation for a specialized lookup?

[Jana]

Looking up data from another data base with multiple related records is my challenge. My original intent was to set up one database (Location Tracking) for the details and upcoming scheduled changes of advertising for specific locations, and one database (Creative Changes) for entering the creative images/headlines/install dates as they change. I wanted to relate the Creative Changes to the Location Tracking via a portal, but it is impractical since the images take up a bit of room per line item and the portal always adds the next potential line item making the whole location image content reporting layout too long per location.

So I would like to just relate the two databases by being able to have the location details fields look up the most resent image/headline/date occurrence.

Is there a calculation I can do to tell the field (ie. Current headline) not to lookup the first occurrence, but rather lookup based on the most recent record entry or most current date?

The databases are relating based on a unique location number field.

Grateful for the help if you can give me any direction.

Thanks!

[Vaughan]

"Looking up data from another data base with multiple related records is my challenge."

Lookups only return the value from the *first* related record. Try setting the relationship to sort the related records by date descending, see if that helps.

[Oldfogey]

Try this.

Define a field, Recent, in your main file as Max(Relship::Date) and then use that Recent plus your regular key to look up your values. Klunky but .....

[Jana]

Thank you for both of these usable solutions...Awesome Aussies!