5 Replies Latest reply on Sep 29, 2015 4:14 PM by director@charlesmoore.org

    Dynamic Value List of Fields in the Same Table

    director@charlesmoore.org

      I have a <humanbeing> table, with the usual fields such as name_prefix, name_first, name_second fields. 

       

      I also set up two calculation fields:   salutation_informal (name_first) and salutation_formal (name_prefix & " " & name_second).

       

      Id like to have a field salutation_chooser, where the user can choose from a value list generated with the actual values calculated by the salutation_informal and salutation_formal.

       

      So, for instance, the value list might have:

       

      John

      Mr. Doe

       

      Is there a way to generate these value lists for each record without having to make an independent <salutation> table?

       

      Thanks so much for any ideas!