Since a formula address field does not exist, I was trying to come up with a way to update a regular address field, with a table to table import, or...??
My situation is I have a 'Combined Table' that merges data from many different areas. There are about 6 address fields, but each record is guaranteed that only one of the address fields is filled in. I want to have a seventh 'Combined Address' field, and somehow fill that field from whichever address field is populated. However, on a table to table import, I am not allowed to choose each specific address field (street 1, 2, etc) and if I try to make a formula field for say, street 1, I cannot simply choose the street 1 field....
Anyone every try to do anything like this before?
------------------------------
Mike Tamoush
------------------------------
