Thursday, 6 October 2011

Multi-Level Master Detail Relationship

A multi-level master-detail relationship can best be explained using this picture below:

In a master detail relationship you can use roll-up summary fields to perform calculations on detail records.
Note: The rollup summary fields work only 1 level deep. (You cannot have roll-up summary fields performing calculation on grand child records)

You can notice the advantages of using a multi-level master-detail relationship when you use reports as well.