Relationship advice

[NathanAshton]

I have attached a database that I've just started working on. It's a flight planning system and involves quite a few calculations for distance time etc.

Per the attached, I have a locations table which is where I want to store preset locations along with their Latitude & Longitude. On the flights table when entering the "LegFrom" I want it to populate Sectors:lat1 & Sectors:lon1 with the details from the location table. I can then run some more of my calcs.

How do I go about bringing this across? I can have it open a popup box which allows you to select a locations and brings it across, but I can't get it to bring across the lat / lon also.

Hope that makes some sense

Cheers

Copy_of_Flying.fp7.zip

[comment]

Something like this?

Note that there is no need to "bring across" the location data - it is accessible through the relationship.

Copy_of_Flying.fp7.zip