Filemaker Pro Advanced 11 showing current record contents instead of relative field
Operating system version
Windows Server 2008 R2
Description of the issue
I set up a pulldown menu with external SQL Server tables as the data source. When I look at fields with ID's, for instance a customerID, I want to show the customerName to the user. I have set up the relative table/field options to show only the list of customer names from another table. However, the customerID for the record always shows up in the list of the names I have selected to show from the relative table. This only happens with the pulldown menu. If I set up a radio button or pop-up menu I do not get this behavior.
Steps to reproduce the problem
Set up a pulldown menu to an external data source with both an ID field and a related text field. Make sure the pulldown menu is pointed at the ID field as this is what you will be updating with a related value from the text field. Attempt to show the user ONLY the related text field in the pull-down menu.
The expected result is you should be able to see the text equivalent of the ID field you have set up in the pulldown menu for the current value of the ID field, as well as show all of the other values from the related text field.
The ID value of the current record always shows up in addition to all of the related text field values. I do not want to see the ID, only the equivalent related value. This only happens with pulldown menus. Radio boxes and pop-up menus do not have this issue.