1 Reply Latest reply on Oct 7, 2012 5:05 PM by philmodjunk

    Combininb Address information



      Combininb Address information


           The group I am with has three regions   As I add new clients to a specific region, how do I best combine the address fields to the name of the region so I don't have to enter the address each time?

        • 1. Re: Combininb Address information

               Add a related table with the region and address fields. Set up a relationship that links your current table to this new table by region fields. Then you can either copy or dynamically reference the data from the related table each time you enter/select a matching region in the region field of your original table.

               Here's a more detailed description of this method as well as a discussion of the pros and cons of using a dynamic link vs a static look up (copy) of the data in the related table: Auto Fill