4 Replies Latest reply on Oct 1, 2015 9:36 AM by director@charlesmoore.org

    Calculation field in a value list.

    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!