The Cities table has just the 400 major cities in the US and Canada, the
ZipCode table has every zip code and postal code for every corner of the two
countries.
The ZipCode table has Longitude and Latitude coordinates for each zip code
(basically each city). The Cities table has Longitude and Latitude
coordinates for each City (or CityID).
What I need to do is match a CityID with a ZipCode. I'd need to select a
zipcode record, then loop through and calculate the distance of each of the
400 cities based on the lat/lon of selected zip code, take the nearest/top
CityID and update the ZipCode table.
For example: (irrelevant data excluded)
ZipCodes Table
ZipCode Latitude Longitude CityID
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
