I need to create a report that shows the most recent records for different serial numbers. The problem is that the person that created the database made it where everything is in one table. There are multiple instances of each serial number throughout the database, but I need to display 1 record for each serial number, and I need each of those records to be the most recent. I am still fairly new to FileMaker. Anyone know how to do this without having to change the table structure?