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.