AnsweredAssumed Answered

Automatically Populate an Address

Question asked by MelissaKreindel on May 14, 2012
Latest reply on May 14, 2012 by davidanders


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!!