12 Replies Latest reply on May 27, 2017 8:40 AM by rouelf

    Calculating distance between current location and multiple locations.


      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.