AnsweredAssumed Answered

Drop-down list

Question asked by ThomasZaat on Dec 28, 2010
Latest reply on Dec 28, 2010 by philmodjunk


Drop-down list


Hi all,

I am new to Filemaker and I hope you can help me with this one:

I have a database with 2 tables:

Table "AirLines" with fields :  Id [Number]  (Auto-Enter serial), and Name[Text]

Table "FlightInfo" with fields : AirLine [Number]  and Flight [Text]

I made a layout "FlightInformation"which shows data from the FlightInfo table, on which I added the FlightInfo::AirLine field.

I changed its control-style to drop-down list. The values for the dropdown come from the value list 'vlAirlines'. This value list gets its values from the Airlines table using fields AirLines::Id, and AirLines::Name.

Now when entering new data in the layout I am able to pick an AirLine from the dropdown list by name, and the airline Id shows up in the FlightInfo::AirLine field.

However I  do not want the id shown on the layout , but the Name of the airline.

It seems to me that this should be relatively easy but I can not figure out how to accomplish this.

Any ideas would be welcome.