Hello!

I am building a custom database for a delivery/trucking business.

There is a field with the current zip code for each driver (record).

I would like to create a querry that will allow me to enter a specific ZIP code in a search field, and based on that to find the closest Driver (record).

It can also be within a radius of 50, 100 miles and so on....

Probably the easier way would be relation with google maps...

Any sugesstions?

Thank you!!!

See If this helps.

http://www.filemakerhacks.com/?p=3802

Not sure if this custom function will help you at all....

http://www.briandunning.com/cf/143

As long as you know GPS coordinates for the pickup location and the driver, it should do the trick.