Add data from value in portal record field
I'm trying to add the distance between two airports.
I have a table called Flights, a table called Airports, and I have a join table called Flight Legs.
I have a PK for flights and a PK for Airports and a corosponding FK for each in my FlightLegs table
I put a portal on my Flights layout. I have a function that calculated the distance between airports based on LAT LONG cordinates stored in the Airports table.
With this setup, how can I get the LAT LONG data from the data in the previous portal row?