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?