Automatically Populate an Address
I am creating a database to keep track of files for a law office. Currently I have two tables: my main table with all the information including the Prison Unit clients are in along with an address field, and a second table that has the prison units and the addresses.
When I enter a specific unit on the main table, I want the address of that unit (which is in the Prison Unit Table) to automatically populate.
For example, when I type in that a client is in the Smith unit, I would like the SMith address (from the Unit table) to just appear.
How can I do this? Thank you!!