#Link multiple products to multiple companies

1 messages · Page 1 of 1 (latest)

pastel vapor
#

Hello! I tried creating a new "Products" object and filling it with different products. I used the relation type "has many" (1:n) and "has one" (n:1).

The problem is there is no "many to many" (n:n/m:n). I managed that:

  • multiple companies can have the same product but they can only have one product
  • multiple companies can have different products but other companies can't use the same product

Is there any option I can use, did I do anything wrong or do I have to wait until there is 1 "many to many" relation type?

warm trench
#

I would create an Assets Object That Object would have a M-1 on Company and M-1 on Products.

pastel vapor
#

I was just wondering because it was moved to "done" but it wasn't released yet. And clever tip, thank you. But I'll rather wait until the many to many relation is released

warm trench
#

With an separate object you can add specifics like price and qty or any other property that is unique to that Companies Product. That is how a lot of CRM's handle it. I am curious how them implement the m-m also.

pastel vapor
#

I mean m:n are just two 1:n in reality