Hi guys,

perhaps a basic question, but unfortunatley I could not figure it out, and did not found anything searching the forum.

I have two tables Route and Airpot:

Route                 Airport
-------------         ------------
Rte_From_ICAO         Apt_ICAO
Rte_To_ICAO           Apt_Name
Rte_Alt_ICAO
etc..
..

When I create a Route in the Route table I want the name of the airport to be displayed (not saved in table) right beside the according ICAO entry.

I managed doing this for the Rte_From_ICAO with a relation to Apt_ICAO. This works fine.

But how to do this for To_ICAO and Alt_ICAO.

Thanks a lot in advance

Hans

You will need (at least) two relationships between the two tables, with (at least) one of the tables having more than one occurrence on the relationships graph.

Here is a minimalistic example. I say "minimalistic" because it does not allow to view the routes to a place from the context of Places.

 

routes.fmp12

THANKS a lot ... that pointed me in the right direction!

Already implemented and working!  👍

BR
HANS