On a layout I have a foreign key with a pop-up menu. The menu is defined as follows:
Show values only from the second field.
This works fine when I'm on the field and choose the user via the pop-up. It produces a list of user names, as expected. However, when I script the process and populate the field MYTABLE::userID with $userID, the pop-up displays the id rather than the user's name (see attached screenshots). I know I can fix this with a Dropdown and a mask field, but is there any way to make the pop-up display the second field from the value list?