data design question

Hi all,

I have a product table where each prod can have from 1 to 10 suppliers
What is the correct way to build those tables?

tblProd tblLink tblSup
1, prod1 1,A A,Sup1
2, prod2 1,B B,Sup2
3, prod3 1,C C,Sup3
2,A

Here product 1 has 3 supplier and product 2 only one.

Is it ok to make a link table or is it somethig to avoid with large amount
of records?



pierre

What you've got, with 3 tables, is the best approach.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"PF" wrote in message
...
Hi all,

I have a product table where each prod can have from 1 to 10 suppliers
What is the correct way to build those tables?

tblProd tblLink tblSup
1, prod1 1,A A,Sup1
2, prod2 1,B B,Sup2
3, prod3 1,C C,Sup3
2,A

Here product 1 has 3 supplier and product 2 only one.

Is it ok to make a link table or is it somethig to avoid with large amount
of records?



pierre