Do not hide the first column value and then you'll see both names. That's not what you want, I know, but that's how FileMaker works here. It's due to how Filemaker builds these value lists from the field indexes and the index only stores one instance of each value in the field--so no duplicates when you hide the first column or when you sort values on the second column.
While I would like to see this more clearly documented in FileMaker help, I don't find this to be a major issue for me.
If you could click on the pop up menu and see "John Smith" listed twice, how is the user to know that the second John Smith, PersonID = 45321, is the correct one to choose and not the first John Smith, PersonID = 2346?
The solution to both getting the duplicate names to appear in the value list and also to help users select the correct name, is to define a text field with an auto-entered calculation that includes more data, perhaps an address line, than just the name. This text field should have a "unique value" validation option specified to make sure that you can't have two records where this text is the same.
With the address included, the user (and your FileMaker value list) can distinguish John Smith, 3421 main street from John Smith, 2345 1st avenue.
I believe I follow your suggestion for generating a text field with the additional, in this case, address information, but wouldn't that additional info then be displayed within the pop-up after the selection has been made? Then as one looks at the displayed values, the name field would have this extra data within it in addition to the extra data displayed within their appropriate fields? Or is there a way to only make this data appear within the pop-up and go away once the selection has been made?
Good point. You may want to use a drop down list with the related name field placed next to it. There are two "tricks" that hide the drop down list formatted ID field while still keeping it in the layout for your user to use. Both require placing the required name field on the layout and using behavior options in the Inspector to prohibit user access to the related name field.
1 ) Add the arrow option and then resize the field until only the arrow is visible. Put it to the right of the related name field so that it looks like the arrow for the name field.
2 ) Put the related name field on top of the ID field and format the ID field with a text color that matches the layout background. When the user clicks on the name field, the drop down behind it pops to the front and deploys.
Rock Star solution! I'm working on it as I type this.
May I buy you a beer?