How to see John Smith and Mary Smith on the same value list?
I have a field with a value list (using values from a field in another table) showing both the first name and family name. It works fine, except that if both John Smith and Mary Smith are on the list, it only shows John Smith.
If, in "Specify Fields for Value List", I choose "Show values only from second field", I can see them both on the list, but still only John Smith loads into the field.
In the help it says this:
"If the value list is defined to display information from two fields, items will not be duplicated for the field on which the value list is sorted. For example, if the value list displays information from the Company field and the Name field, and if the values are sorted by the Company field, only one person from each company will appear in the value list."
So is it impossible to have both John Smith and Mary Smith to be seen and loaded into a field from a value list?