AnsweredAssumed Answered

How do I get 1 record per instance of a certain unique value based on its date?

Question asked by neonwhite on Sep 10, 2018
Latest reply on Sep 10, 2018 by philmodjunk

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?

Outcomes