Related field in pop-up or dropdown
I have a field from a related table which I can put in either a popup or a dropdown menu. In either case, I am storing the foreign id but have the menu set to display only the second field. It appears Filemaker makes you choose between two evils:
1) If I choose a popup menu, everything looks great but I can't access it by tabbing into the field
2) If I choose a dropdown, I can tab into the field but the field displays the key, not the value. I know you can "fix" this by placing a non-enterable field over the dropdown, but when selecting from the dropdown one foreign id always shows at the top.
Is there some trick to get the best of both worlds?