Merging - User Address...???
OK...I'm going to do my best to explain this and not confuse.
I have a database with a table called Users. It has user names, addresses, phones, etc.
I am creating letters which will merge various information in the database.
I have set a variable to insert the current logged in user name, address in the appropriate areas on letters when needed and this is working fine. The problem, some users which would be generating letters can work in two different locations.
I am trying to figure out the best way when creating letters and merging information to put their location in the header (Building name and address) and in the appointment location (building name).
I was thinking that on the user table I can put location 1 name, address and location 2 name, address fields. But what I wondered was if there was a user with only one location could it automatically fill this in the appropriate merge fields and if they had two the user must select which location they would like to use ?
If there is a better way to go about this I'm open to suggestions, I'm learning as I go and may not know all the different capabilities available.