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?
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
Retrieving data ...