I have an <address> table with a field that concatenates all of the data.
Multiple addresses are related to a <company> table.
I want the user to be able to select a desired address for a company for correspondence.
When I set up the related value list for "addresses" however, and I include the concatenation field as the second value, the value list displays values in each of the data fields. (see screen shots.)
Any advice about where I'm going wrong?
Use another char for concatenating. ¶ is value separator.