Coverage Zip Codes

[ServiceEnvoy]

I have a table/form that holds my technician information (contact
information, skill set, certifications, tools, etc.). I need a way
for them to list all the zip codes that they can cover. I set up a
table/subform called "sub_Coverage". I linked it to the techs ID
number so that when you open the coverage table it shows which tech ID
can cover which zip code and there are obviously multiple tech id's
listed.

How can I tie the coverage table back into the tech table to obtain
their contact information? We need to have Mappoint link to the
coverage table data so it will display both the coverage AND the techs
contact information in the map. The coverage table only shows the
tech id though. Any ideas how to get that information into the
coverage table or am I going about this wrong?

 

[Guest]

I'd start my query from the coverage table (by ZIP-code), and link to the
Contact table by ID. Seems like a simple enough query, unless I'm mis-reading
your question.

 

[ServiceEnvoy]

I'd start my query from the coverage table (by ZIP-code), and link to the
Contact table by ID. Seems like a simple enough query, unless I'm mis-reading
your question.






- Show quoted text -

Yes it was simple to do it that way. I'm just such a novice I didn't
know to do it that way. Thanks for helping a newbie with a lot on his
shoulders.

 

[ServiceEnvoy]

Yes it was simple to do it that way. I'm just such a novice I didn't
know to do it that way. Thanks for helping a newbie with a lot on his
shoulders.

Is there anyway to just start within Access to find the closest techs
to a job using ms mappoint or google maps? I would like to be able to
enter a zip code in access and have it allow me to email all the techs
within a certain driving range with certain skill sets and then mark
them as having been contacted (so we can track whether they are
responding over time).