Want to add a layout to track notes on records, but only the latest note on each
I have a database tracking NBA and college baketball players. In July it is a big free agency month and I wanted to track the latest information on just the free agents. I have a layout that lists all the free agents in the NBA, and I would write notes that I get from the news wire. I want to create a way to only track the latest note that I wrote about a player. I created a table just for free agency notes and I linked it by the player id. Issue is it only lists the first note I write about a player. SO for example if I write info on a player today and then there is some new intel a week from now and I enter it, it only lists the first one where I just want it to list the latest entry.