I need a clue on how to design a Many to Many relational database.
For example, I have a products table and a supplier table.
each product can be supplied by many suppliers
each supplier can supply many products
how can I orgranise this data in the tables?
I'm using MySQL.
The only way I can think of now is to create a third table and store the relationships ie.
'product_supplier' table with 2 fields: product_id, supplier_id
Any better ideas to share?
Thanks in advance!