Setup a record with multiple values under a field 1

[Aasin]

Hello all,

I am using a access database to house company information pertaining to a county in a state. Some of the companies are referenced in different counties and may have additional counties in the future. This is my issue. I have the companies data in a table and the counties in another table. How do I link a company with more than one of the counties. So for example. A user wanted to know how many counties does the company support.

 

[Remou]

Hi
I think the best bet would be a third table with two fields, CountyID and CompanyID.

 

[Aasin]

I have created the third table with the company ID and County Id. I see where it is linked. I do have another question.

If another company was to be added and it supports every county in the database. How would I configure that one company with all the county id's since it supports all the counties?

 

[Remou]

I think I would put the company in for each county, rather than having an All, because of queries.

 

[Aasin]

I had a feeling I would have to do that. So, basically copy and past the company into each county.

Thanks for all your help!