Autopopulating Across Tables
I'm creating a rental inventory database.
I have a table for equipment information. There is a field for "Current Location"
Keyed via a UID I have a table to record individual transactions. I want to autopopulate the "Current Location" field based upon the most recent transaction in the transaction log.
What is the best way to manage that?