Activity Forums Salesforce® Discussions What is Master Detail relationship and look up relationship in Salesforce?

  • shariq

    Member
    September 22, 2018 at 10:28 pm

    Master Detail relationship is the Parent child relationship. In which Master represents Parent and detail represents Child. If Parent is deleted then Child also gets deleted. Rollup summary fields can only be created on Master records which will calculate the SUM, AVG, MIN of the Child records.
    Look up relationship is something like “has-a” (Containership) relationship. Where one record has reference to other records. When one record is deleted then there is no impact on other records.

  • Parul

    Member
    September 23, 2018 at 3:48 am

    It is a custom field which links one object record to another. Through the creation of relationships, we can display the data of all the related records in the record's details page. The Master Detail relationship is used when we want to control the display ofdetail records based on the value in the master record.

  • Avnish Yadav

    Member
    September 30, 2018 at 4:50 am

    Hello,

    Lookup Relationship:
    This type of relationship links two objects together. This is loosely bounded. We can use lookup when objects are only related in some cases. Objects in lookup relationship usually work as standard alone objects.

    Master-Detail Relationship:
    This is Parent (Master) Child (Detail) relationship in which the master object controls certain behaviors of the detail object. This is tightly bounded.
    For Ex – In program Event Management with a Master-Detail between Events and Budget, you can delete the Event and the entire related Budget.

    Thanks.

  • Divya

    Member
    October 25, 2018 at 3:18 pm

    Hi Aman,

    A lookup relationship essentially links two objects together so that you can “look up” one object from the related items on another object.Lookup relationships can be one-to-one or one-to-many. for example The Account to Contact relationship is one-to-many because a single account can have many related contacts.

    Master Detail Relationship: in this  one object is the master(i.e; Parent) and another is the detail(i.e; Child). The master object controls certain behaviors of the detail object, like who can view the detail’s data.

Log In to reply.

Popular Salesforce Blogs