An administrator at Universal Containers is tasked with displaying the total calculated value of all associated custom Invoice records directly on the Account record page. When trying to create a new custom field on the Account object, the administrator notices that the Roll-Up Summary field type option is greyed out and unavailable. What is the reason for this limitation?
- The Invoice custom object is linked to the Account object using a Lookup relationship instead of a Master-Detail relationship.Answer
- BRoll-Up Summary custom fields can only be defined on child objects, not on parent objects like Account.
- CDeleting a parent Account record retains child Invoice records, which violates Roll-Up Summary field calculation rules.
- DStandard objects such as Account only support Roll-Up Summary fields when aggregating standard child objects like Opportunities or Cases.
Answer
The Invoice custom object is linked to the Account object using a Lookup relationship instead of a Master-Detail relationship.
Roll-Up Summary fields are exclusively available on the master object in a Master-Detail relationship. Because the relationship between Account and Invoice is configured as a Lookup relationship, the Roll-Up Summary field option is disabled.
Step-by-Step Solution
Key Concept
Roll-Up Summary Field Relationship Requirements