Display in header the 1st and last record of the page
I have a simple and flat FMP database that is a catalog of content formatted very much like the old white pages phone book. Just like in a phone book, I wish to display in the header of each page the contents of one field from the first and last records on that page. So basically, if the page starts with the last name "Miller" and the last name on that page is "Numbskull," the header would display, "Miller - Numbskull."
If I place the desired field in the header, I get the field from the first record on the page - great. If I place that field in the footer, I get the value from the last record on the page - okay. I just can't figure out how to grab that last record value and display it in the header!
Many thanks in advance for any guidance on this quandary.