Thanks, Naomi!
>>I'm working on a program where a user wants to enter a town into the system and receive a listing of records based upon 20 miles or so (user configurable) radius of that zip code. I assume(?) there is a logical layout to zip codes to make this possible as I see it on websites all the time. Has anyone worked out a procedure or resources to accomplish this?
>>
>>Example: enter Denver, CO
>>returns: all records for Denver, nearby Aurora, Centennial, Englewood, etc.
>>
>>
>>If there's a plugin that accomplishes this that could be embedded in VFP, that would work too.
>>
>>Thanks in advance.
>>
>>Steve Howie, owner
>>DaSH Technology, LLC
>
>Please check this link
http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/sql-server-zipcode-latitude-longitude-pr - It is in SQL Server, but perhaps you would be able to adapt the ideas - it doesn't seem hard.
Steve Howie, owner
DaSH Technology
Denver, CO