Activity › Forums › Salesforce® Discussions › What is Master Detail relationship and look up relationship in Salesforce?
Tagged: Look Up Relationship, Master Detail Relationship, Parent Child Relationship, Salesforce Custom Field
-
What is Master Detail relationship and look up relationship in Salesforce?
Posted by Aman on September 22, 2018 at 10:28 PMWhat is Master Detail relationship and look up relationship in Salesforce?
Divya replied 7 years, 6 months ago 5 Members · 4 Replies -
4 Replies
-
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. - [adinserter block='9']
-
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.
-
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.
-
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.