Drop down lists, show 2nd field
As a former Access user I'm used to having drop down lists to select a key field that instead of displaying a serial number displays an alternate field. For example having a table of locations with fields LocationID and Location_Name. I can get the drop down (in another table) to show the location name but then it displays the LocationID which is not human friendly. What am I missing here or is there a way to handle this that I'm just not getting?
FM 10 Pro on Snow Leopard.