data design question

[PF]

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

 

[Douglas J. Steele]

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