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?