AnsweredAssumed Answered

Add data from value in portal record field

Question asked by JamesPeragine on Feb 11, 2015
Latest reply on Feb 11, 2015 by JamesPeragine

Title

Add data from value in portal record field

Post

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?  

 

 

portal_row.png

Outcomes