Question

Difficulty: MediumCustom Fields and Data Types

A Salesforce administrator at a biomedical equipment laboratory is configuring custom fields to track service metrics. The laboratory has a parent custom object, Equipment Model, and a child custom object, Calibration Inspection. These two objects are currently connected by a Lookup relationship. The operations manager requires a field on the Equipment Model record that automatically calculates the total count of related Calibration Inspection records. When attempting to create a new field on Equipment Model, the administrator finds that the Roll-Up Summary data type option is disabled. Which configuration action should the administrator take to meet this requirement?

  1. Convert the Lookup relationship on Calibration Inspection to a Master-Detail relationship, and then create the Roll-Up Summary field on Equipment Model.Answer
  2. B
    Create a standard Roll-Up Summary field directly on the parent object by selecting the existing Lookup relationship as the summarize target.
  3. C
    Configure Lead Custom Field Mapping to automatically calculate and transfer aggregate counts to the Equipment Model object.
  4. D
    Enable the Roll-Up Summary field type by adding the target field to the parent object's Record Type picklist assignment.

Answer

Convert the Lookup relationship on Calibration Inspection to a Master-Detail relationship, and then create the Roll-Up Summary field on Equipment Model.
Roll-Up Summary fields are only supported on the parent (master) object in a Master-Detail relationship. Converting the existing Lookup relationship between the child object (Calibration Inspection) and parent object (Equipment Model) into a Master-Detail relationship removes the restriction, enabling the administrator to create the required COUNT Roll-Up Summary field.

Step-by-Step Solution

1
Identify the relationship constraint for Roll-Up Summary fields.
Recognize that Salesforce natively allows Roll-Up Summary fields only on the master side of a Master-Detail relationship.
Lookup relationships do not support native declarative roll-up summary functionality.
2
Change the relationship type on the child object.
Ensure all child records have a populated parent lookup field, then convert the lookup field on Calibration Inspection to a Master-Detail relationship.
Master-Detail relationships require every detail record to be linked to a parent master record.
3
Create the Roll-Up Summary field.
Create a new custom field of type Roll-Up Summary on Equipment Model, selecting COUNT of Calibration Inspection records.
Once the Master-Detail relationship is established, the Roll-Up Summary option becomes available on the master object.

Key Concept

Roll-Up Summary Field Capabilities and Relationship Requirements
Rate this question