Odd thing... I changed a field from dropdown to popover and the field contents render differently for a single entry.
My layout has a value list derived from a table (Role ID and Role Description).
In a portal record where I'm entering info, when the Role ID is formatted as a dropdown, it renders correctly (i.e. just the Role ID shows).
When the field is formatted as a popover, it renders with the Role ID and the first couple of characters of the Role Description.
Playing around with it reveals that when "Override data formatting with value list" is unchecked, the popover renders as desired (i.e, just the Role ID). I'm sure this is expected behavior, but can someone please explain what and why this is?
Displaying an ID to the user doesn't mean anything to him, it's in fact internal management. A dropdown can only display the ID - the first field in the Value List setup - , not the name of the value - the second field in the Value List . At some point in time though, FMI added an option to a pop-up menu, that is to display that name, for example Film in one of your examples. Thing is the value saved in the field is the ID, the name is for display only.
IMHO it's unfortunate that we can't do the same with dropdowns.
I think perhaps I wasn't clear. I thought it odd field behavior that it would show both fields (2nd image) only when the ID was 12. For all other values, the popover worked as expected.
I wound up going back to a dropdown for a couple of reasons. For data entry, I prefer being shown both the ID and Name, and being able to type the ID on my numeric keypad. I only use a mouse when absolutely necessary because it slows down data entry.
This is a feature to allow you to show the Second Field involved in a value list, but store the actual ID value used in relationships. I rarely use it, since almost all pickers I build now are based on card windows, or at the least a portal in a pop-over button.