dbTalk Databases Forums  

Many comapanies and many zips

comp.database.ms-access comp.database.ms-access


Discuss Many comapanies and many zips in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dancing Bear
 
Posts: n/a

Default 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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.