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.