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:
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!