AnsweredAssumed Answered

Drop down lists, show 2nd field

Question asked by vipero00 on Jan 13, 2010
Latest reply on Mar 22, 2010 by FentonJones


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.