data design question

  • Thread starter Thread starter PF
  • Start date Start date
P

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
 
Back
Top