director@charlesmoore.org

Calculation field in a value list.

Discussion created by director@charlesmoore.org on Oct 1, 2015
Latest reply on Oct 1, 2015 by director@charlesmoore.org

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?

 

 

Thanks!

Outcomes