Activity Forums Salesforce® Discussions Why can't a Salesforce Junction Object be on the master side of another master-detail relationship?

  • shariq

    Member
    January 5, 2018 at 11:44 am

    Hi Rahul,

    First we need to know why we create junction object---

    We create junction object to get many to many relationship functionality, a many to many relationship allows each record of one object to be linked with many records of another object or vice versa.

    Salesforce allows only two master detail relationship on any object, as junction object has two masters so when we make master detail field on another object, the name of that junction object will not be shown in the 'Related To' picklist.

    Hope this helps.

     

  • Ajay Prakash

    Member
    January 6, 2018 at 9:26 am

    If the junction object has two parents (Master-Detail), then the Junction Object can’t be on the master side of another master-detail relationship because You can't create a master-detail on an object with two master-detail. It's a limitation of the system. However, not all junction objects have two master-detail relationships, so it is indeed possible to create a master-detail relationship where the master is the junction object.

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos