Forum Discussion

Medmbchr's avatar
Medmbchr
Icon for Helper IV rankHelper IV
3 years ago

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...
Need Help
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
3 years ago

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?

Medmbchr's avatar
Medmbchr
Icon for Helper IV rankHelper IV
3 years ago

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

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    3 years ago

    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?