I am creating an Access DB for the first time in years and in doing so have forgotten how to update fields from two separate tables.
Here is what I am trying to do:
When a user selects a store that is linked as a lookup of the second table.
I want the address to autofill from the second table and update the first.
How would I execute that?
Here is what I am trying to do:
When a user selects a store that is linked as a lookup of the second table.
I want the address to autofill from the second table and update the first.
How would I execute that?