AnsweredAssumed Answered

Drop down box with SQL Server

Question asked by katieandemil on Feb 7, 2016
Latest reply on Feb 7, 2016 by Fahri Akar



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