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