AnsweredAssumed Answered

Want to add a layout to track notes on records, but only the latest note on each

Question asked by MikeProcopio on Jul 2, 2012
Latest reply on Jul 5, 2012 by philmodjunk

Title

Want to add a layout to track notes on records, but only the latest note on each

Post

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.

Screen_Shot_2012-07-02_at_2.10.19_PM.png

Outcomes