How to show only the latest record of a group of records
I am experimenting with an app to track equipment. One of the tables has essentially two lookup fields. One is a piece of equipment from an equipment table, and one is a location from a location table.
A given piece of equipment might be moved to a lot of locations over a period of time. I want to keep this information in the table, but I want the ability to only display the latest record in the table since that is where the equipment is now. I would like to have an option to show all of the records if the user wishes so they can see everywhere the equipment has been.
Are there any examples of this kind of view that I could look at? Any info is appreciated
Dave