Find Nearest Record
I'm having difficulty writing a script to find contacts that are located within a set distance to another. For example, have a layout that displays distributors within 10 miles of a customer.
The only data available is address data and no geo data. I've realised that I'll probably need extra data containing contacts' coordinates for their nearest distributors to be calculated, but I have no idea where to find that or if I'll ultimately need to use a plugin.
Can any recommend a way to go about this, such as using a plugin. I've been searching for quite a while but can't seem to find anything for Filemaker that does this.
Any help would be appreciated.