I have recently started using File maker 14 Pro and I use it with SQL Server (back end).
One of my basic needs is to have a drop down box.
I have created a drop down box, however the field that holds values shows ID instead friendly name that makes sense to users.
My questions is, is there a way to display friendly name instead of ID (Value behind the scenes, but display description from look up table), so like a normal drop down box on website and everywhere else (without workarounds or using pop up menu).
Many thanks in advance