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