AnsweredAssumed Answered

Dynamic Value List of Fields in the Same Table

Question asked by director@charlesmoore.org on Sep 29, 2015
Latest reply on Sep 29, 2015 by 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!

Outcomes