I am a new user of FMP.
My database contains two tables:
Trips contains the following field:
Field name: Itinerary
Field Contents: JFK - DEN - SEA
Airports contains the following field:
Field name: Code
Field Contents: JFK, DEN, SEA, etc.
Field name: City
Field Contents: New York, Denver, Seattle, etc.
How do I create a new field in Trips that translates JFK - DEN - SEA to New York - Denver - Seattle?
I am using FMP 11.