AnsweredAssumed Answered

Autopopulating Across Tables

Question asked by RyanMutton on Dec 19, 2013
Latest reply on Dec 19, 2013 by philmodjunk


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?