AnsweredAssumed Answered

Find Nearest Record

Question asked by MatthewLowe on Apr 14, 2011


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.