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

    Dynamic Value List of Fields in the Same Table


      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:



      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!