Data from last records in a group
FM 11 Adv. I’m looking for a way to extract data from the last record in each group of records in a child table.
For example: A table Author has author names and the child table Book has the books written by each author. How can I create a report that contains only the name of the last book published by each author?