Forum Discussion
Relationship between two tables
Hi I would like to know in your opinion how can I build a relationship between the following two tables to avoid a many-to-many relationship: The idea is that I have 4 distinct products, howe...
the only way you can get around a many to many relationship is to create a unique combination of the products required, otherwise how will you know what other products it is referring to?
I didn't quite get your point, but in the meantime i created a bridge entity between the two table with a list of all unique accessories that link both table
that makes sense to do, as long as you know which products are being used in that particular order. your question was that you wanted to take the main product and then multiple the same number to the accessories with that product. so has your solution solved this issue?