0 Replies Latest reply on Apr 14, 2011 8:53 AM by MatthewLowe

    Find Nearest Record

    MatthewLowe

      Title

      Find Nearest Record

      Post

      Hi,

      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.

      Thanks.