AnsweredAssumed Answered

Dynamic Value List of Fields in the Same Table

Question asked by on Sep 29, 2015
Latest reply on Sep 29, 2015 by

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!