Activity Forums Salesforce® Discussions What is the Difference between Master Detail and Lookup Relationship in Salesforce?

  • Laveena

    Member
    August 22, 2019 at 4:46 am

    Hi Somendra,

    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
    When you delete the master it will cascade delete all detail records relating to that master. A typical use of a Master-Detail would be the classic Sales Order and Sales Order Items objects.

    Lookups are generally for use where you may or may need to have a relationship between two objects (but not always).
    Lookups are generally used to reference commonly shared data, such as reference data.
    Lookups are used to link two objects together when you don't want the behaviour of the master-detail - particularly around sharing rules, profile permissions and cascade delete.
    Lookups are used when you need to relate multiple 'parents' to the detail record.

    Thanks

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos

Salesforce Integration Tutorial | Integrate Salesforce with Apps

Video in

This "𝐒𝐚𝐥𝐞𝐬𝐟𝐨𝐫𝐜𝐞 𝐈𝐧𝐭𝐞𝐠𝐫𝐚𝐭𝐢𝐨𝐧 𝐓𝐮𝐭𝐨𝐫𝐢𝐚𝐥" video by Edureka will help you understand what is Salesforce integration in detail. It will also address the various Salesforce integration…

Salesforce Interview Questions and Answers - For Freshers and Experienced Candidates

Video in

Learn most important Salesforce Interview Questions and Answers, asked at every interview. These Interview questions will be useful to all entry-level candidates, beginners, interns, and…