Have you tried using a 2 column value list where column 1 is the key field and column 2 is the description?
Yes I have. But when I select a new value, the description is displayed in the dropdown but then the Action_ID is displayed when the dropdown rolls up. In the field/control setup, for Display Data From, that should be from Table 2 since there will be multiple records.
Table 2 should be:
If I have Action Description set to be displayed, after I select a new value from the drop box, it is Action_ID that appears.
This is a known limitation of filemaker. I know of two solutions, neither are perfect:
Format your field as a pop-up menu instead of a drop down list. For some reason, pop-up menus formatted with a 2 column, first column hidden value list, will display the 2nd column even though your menu action has correctly input the ID number into the field itself.
Put the matching related description field next to your drop down formatted ID field. Format your field to use the drop down arrow and resize the field so that ONLY the drop down arrow is visible. This gives you:
this will look like what you want even though its really two fields.