Data model - N:N Relationships on Custom Objects
I've created new object called "Deals" and I was hoping to attach a person as "Deal Partners" however, the issue that I'm seeing is that the N:1 relationship is only attaching to a single deal.
Deal1 relating (attaching) Person1 & Person2 (Goes just fine)
Deal2 relating (attaching) Person1 & Person2 (Goes fine, BUT strips Person1 & Person2 from Deal1)
In essence I'm unable to attach two or more people to more than one Deal.
What am I missing here?
11 Replies
I can say I'm reproducing it but now I'm trying to understand if it's really N:1 or N:M relation at this point
@Raph you're trying to make N:M relation which is currently not supported
Hi @bob - stepped away for a few mins. So looking to establish a Deal - to - Many People relationship.
Had that backwards 😅
No problem, just in case I'm adding a nice visual explanation the difference between 1:N and N:M relation
So if you want to have 1:N relation between Deal and People, it's possible only if records from People don't overlap and since you're trying to have linked the same records between said deals, you're breaking the constraint of 1:N relation
you're right..
🤔 might be M:M
Well, it is
yup
ok, so the limitation here is that 1 person can have many deals. However, many people can't have many deals.
Exactly
Changed the post to better reflect the discussion.
Ok, so I tested that theory. Can I send you a DM with a video?
Sure
For those that care, I settled on the 1:N relationships. This allows me to have 1 person owning many deals.
Thanks to @bob 🍻