List of manufacturers & a list of their distributors

[Jonny]

I have a list of manufacturers & a list of their distributors. The relation is many to many. How to build one or two tables & to select correctly the primary key.

Thanks

 

[neileg]

You will need a junction table. Do a search as this is well covered in these forums.