fmpuser0

Data Lookup and Concatenate

Discussion created by fmpuser0 on Apr 20, 2017
Latest reply on Apr 20, 2017 by philmodjunk

I am a new user of FMP.

 

My database contains two tables:

 

  1. Trips
  2. Airports

 

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.

 

Thank you.

Outcomes