2 Replies Latest reply on May 14, 2012 5:09 PM by davidanders

    Automatically Populate an Address



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