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.