I'm using the MapPoint control in an Access application.
I would like to write a program to get the county for each city and state in a table of store locations.
The map I am opening with my control also has many territories defined which are composed of groupings of counties. I'm really trying to get the territory name for each city/state in my retail outlet table.
My original approach was to derive the county that a city was in and then cross reference with my territory/county table to derive the territory, but it would be more direct just to derive the territory based on the city/state of a location.
Has anyone ever done this or have a suggestion?
Thanks in advance