Activity Forums Salesforce® Discussions How many "Master-Detail Relationship" type field can we create in a particular salesforce object ?

  • Prachi

    Member
    August 27, 2019 at 4:53 am

    Hi,

    Master-detail relationship is like parent-child relationship where, master represents a parent and detail represents a child in which master object controls some behaviors of the detail object. Like whenever a Master object record is deleted then the detail object related to it also gets deleted.

    Master-detail relationship can be defined between custom objects or between a standard object and a custom object. The detail object automatically gets the security and sharing settings given to the master object.

    There are some limitations in Master detail relationship-

    1. Only up to two master detail relationships we can create for a particular salesforce object.
    2. We can have only Upto three levels of custom detail levels.
    3. We can’t create a Master-detail relationship when the custom object already contains data.
    4. Each object is allowed to have one or two masters or up to 8 details.

    Thanks.

  • Shubham

    Member
    August 27, 2019 at 6:18 am

    Each object is allowed to have one or two masters, or up to 8 details.

  • Saddam

    Member
    August 27, 2019 at 9:03 am

    Hi Nikita,

    Only up to two master-detail relationships are allowed for an object.
    You can have only Up to three levels of custom detail levels.
    We can’t create a Master-detail relationship when the custom object already contains data.
    Each object is allowed to have one or two masters of up to 8 details.

  • Phil

    Member
    October 19, 2022 at 9:25 am

    Can you point to where you got the figure of 8 details?

Log In to reply.

Popular Salesforce Blogs