AnsweredAssumed Answered

Maximum ID from Related Record

Question asked by rmittelman on Jan 1, 2016
Latest reply on Jan 2, 2016 by rmittelman

I have a job-search database.  One table, Agencies, has a one-to-many relationship with another table, Jobs.

I would like to list the agencies in descending order of activity.  So the agency with the newest job entered would be first in the list.

This seems easy, but I'm blanking on how to accomplish it.  I think I need a field in each agency record containing the highest job ID of its related records.  I just can't remember how to do this.  Any help is appreciated.