Drop Down box behaviour
I am building an HR application in Filemaker 12 and am having some difficulty with drop down boxes...
I have a field called Current Post which needs to look up a list of Posts (table Posts with a Post ID field etc). I need the field to store the Post ID and display the Post Name. My lookup list is from the Post table and uses the two fields Post ID and Name.
If i use a Pop Up menu this works perfectly, allowing the user to select a Post by name and stores the ID value. However if I use the Drop down type field while the drop down list shows the names, the field only displays the ID value.
Clearly I can't use the Pop up menu option because there could be hundreds of Posts in the Post table - what am I doing wrong??