Forum Discussion
Relationship between two tables
Hi
I can't use a combination since each accessory is unique on the customer table, while my main product is also in that column where my accessories are since the main product and accessories are "products"
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?