Many comapanies and many zips -
12-16-2003
, 01:27 PM
I have a table that lists a couple hundred companies.
Each company covers one or more zip codes.
Each Zip may be covered by more than one company.
I need to be able to query a company and show all zips covered (1 or
more zips possible).
I also need to be able to query the Zip and show all companies
covering that zip (again may be one or more).
What I Don't want - if at all possible is:
If a company covers 5 zip codes, I *don't* want to have to have the
company listed 5 times in the table (one for each zip)
If a Zip is covered by 4 companies, I Don't want to have to have the
Zip in the table 4 time (one for each company)
Thank You for any help you can give me. |