March 24, 200916 yr 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
March 24, 200916 yr 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
Create an account or sign in to comment