Hi,
In the relationship interface where you pull lookup fields from the Parent relation into the Child relation -- in the Child relation ( the right side ) you should have [Airport Name] as the proxy for [Related Airport]. Then, from the Parent side ( left side ) pull in lookup fields to the Child side.
When you select Airport Name in the Request form, you can use the Record Picker option wherein you can specify three fields. One of them can be the ID# of the Airport Name ( Related Airport).
Add the lookup fields to the Request form. When you select your Airport Name, the lookup fields will auto-populate if there is information in the Airport table's records to pull.
