Find the Latest

[The Headache]

Hi-

Hope I'm in the right forum. Please excuse if not.

Is this possible?

I have records with a job number and job date.

I have clients that have multiple job numbers in those records.

Can I end up with a found set of each clients latest job?

In other words I need a list of the latest job of all clients

Thanks for any help.

[RalphL]

You could make a calculated field in the Client table using the Last function with a relationship based on Client ID.

[bcooney]

Define latest job. Ralph's approach will get the the ID of the last job entered. If you want to use job dates to determine what's "last," then you need to sort the relationship from Clients to Jobs by job date desc. By placing the JobID and Name on the client list, you'll have their "last" job given you want the one with the most recent date.