Question

Difficulty: EasyCustom Fields and Data Types

An administrator at a real estate agency wants to create a field on the custom Property object to automatically count the total number of related inspection records. However, the Property object and Inspection object are linked using a lookup relationship. Which statement explains why the administrator cannot create a Roll-Up Summary field to meet this requirement?

  1. Roll-up summary fields can only be created on the parent object of a master-detail relationship, not a lookup relationship.Answer
  2. B
    Deleting parent records in a lookup relationship automatically cascades deletion to child records and invalidates summary calculations.
  3. C
    Roll-up summary fields cannot function until all picklist values for the child object are explicitly assigned to a record type.
  4. D
    Custom fields on lookup relationships must first be mapped through Lead conversion settings before summary calculations are permitted.

Answer

Roll-up summary fields can only be created on the parent object of a master-detail relationship, not a lookup relationship.
Roll-up summary fields are a native feature restricted exclusively to the master side of a master-detail relationship. Because the Property and Inspection objects are connected via a lookup relationship, declarative roll-up summary functionality is unavailable.

Step-by-Step Solution

1
Identify the relationship type between the parent (Property) and child (Inspection) objects.
The objects are connected via a lookup relationship.
Salesforce feature availability for aggregate fields depends strictly on the underlying relationship architecture.
2
Evaluate the capabilities and constraints of Roll-Up Summary fields.
Roll-Up Summary fields are exclusively supported on the master object in master-detail relationships.
Lookup relationships do not enforce the strict parent-child data dependency required for declarative roll-up calculations.

Key Concept

Roll-Up Summary Field Capabilities and Limitations
Rate this question