What type of relationship should we have? An object called "House" is related to Opportunity, there can be many Houses per Opportunity. On houses, we have a field named "Square feet". We need to show the total of Square feet for all houses on each Opportunity. Â
A. Lookup B. Master detail C. Junction D. Cross object
Correct answer is option – master detail
Master - detail relationship is a custom field which links one object to another. Through the relationship, all data of related records can be displayed in the record’s detail page. In this relationship one object is the master another is the detail.
The master object controls how the object detail acts. Just like the example above, the master object is “opportunity” and the detail object is “House”. When creating master - detail relationships, fields are always created on the detail object, just like the field named “Square feet” in the example above.
There is only 2 master detail relationship available per object and it can have up to 3 custom detail levels.