Help

[Anon]

Hello,

I would like to know, if a products table and an orders table have a many to many relationship between them. Why this relationship does not work and what must be added to make it work?

Thank you for you help.

[santo]

You have to add a table in between the other 2. This relationship does not work becuase a product can be on multiple orders, but an order can also have multiple products.

Put a temp table inbetween wich sotres the id of the product with the corresponding order id.

[Anon]

Thank you very much for your help.