AnsweredAssumed Answered

How to keep my dates up to date

Question asked by tomplant on Jun 13, 2018
Latest reply on Jun 14, 2018 by keywords

I apologize for the super newbie question here, but - I'm making a music practice database. I have a master list of tunes and then a related database that tracks when I practiced that tune. In my master list, I want to pull the latest date of practice and put it in a field. Then I can keep up with practicing all the tunes I know by calculating how long it has been since I practiced and sort the tunes by the number of days (descending).

 

I've tried making it a calculation and pulling the date from the related field, but that doesn't seem to change every time I have a new practice date. Any thoughts of the best way to populate the "last practiced" date field in the master list with the "date" of the latest related database practice session?

 

Thanks!

Tom

Outcomes