AnsweredAssumed Answered

Calculating distance between current location and multiple locations.

Question asked by denns on May 23, 2017
Latest reply on May 27, 2017 by rouelf

CurLoc=current location

I need to calculate distance (formula known) between current location and 2000 locations records stored in a table and then pick the shortest distance. I'm learning Filemaker as we speak but am not a professional.

 

e.g. CurLoc to CYBW, CurLoc to CYEG, CurLoc to CYQF and then pick the shortest distance. Basically I'm comparing current location to multiple locations in an airport database and then picking the airfield thats closest to my location.

Outcomes