Relation with multiple fields

[HGS]

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

[comment]

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

[HGS]

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

Already implemented and working!  👍

BR
HANS