Connecting two columns in one table with one reference table without duplication

Dear community,

I am trying to create a relationship between two columns in a table (call it "Flight information") that has flight schedule information and a table that contains details on origin and destination airports (call it "Airport information"). I want to link both origin and destination airport code to the same unique key in the table that contains airport details.

What is the recommended practice in this case? My problems are:
- If I manually connect both codes from "Flight information" to "Airport information", I have to make one relationship inactive;
- Furthermore, if I manually connect as described in the point above, I will be unable to pick the right detail from the "Airport information" table for use in the dashboard (ie I won't be able to distinguish whether I want the details to show for origin or destination airport).

One way around this problem would be to duplicate the "Airport information" table into "Origin Airport information" and "Destination Airport Information". However, wouldn't this be an inefficient duplication of data?

Thanks in advance for your help, 

Luca