Table design question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I've been trying to figure out how to set up this table that I need for a
database that I'm working on, but it's all been in vain.

Access 2003

tbl_Countries: ---> 44 records
countryCode (PK)
countryName

tbl_Pricing: --- 160 records
productID (PK)
companyPID
Price

And now the one that is giving me headaches
Each particular product can be "covered" or "not covered" at each particular
country.
And my question:
Am I stuck creating a three column table like this:
tbl_coverage: ---> 7040 records (160 products x 44 countries)
countryCode
productID
coverage
This table would have to have a "PK" from the combination of countryCode and
productID.

Or is there a more efficient way of getting this done?

Thanks
JC
 
Back
Top