14 Replies Latest reply on Jul 5, 2012 11:11 AM by philmodjunk

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

    MikeProcopio

      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