I'm looking for a way to mark certain records as the last in a series, but I can't figure out a way to do it using Max Summary or Reverse Lookups. Here's the architecture:
Parent: Services < Child: Time Cards
A given Personnel might file multiple Time Cards at a certain address (a lookup to the Services table) on a single day. That is, a Personnel might work on several Services at a single address on one day. I want to indicate which of these was the last one filed (could be the max Record ID#), for each Personnel, per day. Here's an example:
On Tuesday 11/1, Jason performs three services at 13 Main Street, and two services at 450 Central Avenue. He files 5 Time Cards, one for each of the services. I want to mark 2 of the time cards from that day, the last one from 13 Main St and the last from 450 Central Ave.
Note that a given Service record may have many such marked child Time Card records, since I only want to mark one per day per Personnel. Any ideas?