Link multiple products to multiple companies
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?
5 Replies
I would create an Assets Object That Object would have a M-1 on Company and M-1 on Products.
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
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.
I mean m:n are just two 1:n in reality
M:N relation will be implemented this year https://github.com/twentyhq/core-team-issues/issues/188
GitHub
Introduce many-to-many relationship · Issue #188 · twentyhq/core-te...
We should introduce many-to-many relationship (the Salesforce way i.e. not as a field type but as a qualifier on one-to-many relationships)