Toggle Side Panel
Close search

Activity › Forums › Salesforce® Discussions › When should you use lookup instead of a master-detail relationship in Salesforce?

Tagged: , , , ,

  • Avnish Yadav

    Member
    August 1, 2018 at 6:29 AM

    Hi Prachi,

    It would totally depend on your requirement on what will help you achieve your target.
    If you want the child to be deleted, go for master-detail.
    If you want the child to inherit the sharing setting of the parent, go for master-detail.
    If the child required to have a mandatory parent, go for master-detail (though this can be implemented using lookups as well) otherwise go for lookup.

    Thanks.

  • Parul

    Member
    September 28, 2018 at 5:09 PM

    The key difference is master-detail has a direct dependency between the objects:
    You cannot have a detail record without a master.
    The detail record inherits sharing rules from the master.
    You cannot update the relationship to the master in a master-detail relationship.
    The number of master-detail relationships you can use are limited.
    You cannot set profile object permissions for a detail record
    Master-detail relationships are automatically included in report record types

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos