This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Master Detail Relationship
Master Detail Relationship
The master-Detail relationship is a type a cross-object relation that creates a strong relation between two records in which the detail record cannot be separated from its master.
There’re 5 main difference with the LookUp relationship:
- Security & Sharing
Security on the detail object is “controlled by the parent”, which means that the access on the detail record is managed by the user’s level of access to the master record. So it’s not possible to share detail records only. - Ownership
Detail record does not have an owner. - Delete
Since the relation is strong, consider that when you delete a master record, all the associated detail records are deleted as well. - Reports
The detail object cannot be analyzed alone, they will always be displayed in report with information from the related master record./em> - Roll-Up Summary Field
It’ s a type of field available only for the Master-Detail relationship. This field is displayed on the master record (read only), and allows synthesizing values (number or currency) from associated detail records. For example, display the sum of all opportunities on the master account.