03-07-2011 05:00 AM - edited 03-07-2011 05:29 AM
You need to expand the address record and add latitude/longitude - the rest is straight forward computer science/basic math (trig).
Here are come sites that have some free code:
Take a look hare as well:
NOTE: BE careful because some of these approaches can lead to error in short distances - The "circle" approach can be off up to 3%.
We recommend http://www.zip-codes.com to our clients. The standard version will supply you with all the raw data you need. AT $399/year.. not to shabby!
04-08-2011 12:40 PM
Larry - we already developed such a solution. We call it "Proximity Search" and we have versions for both SLX Windows and Web 7.5.
Send me an email if you want more information and pricing.