A Salesforce Administrator at a renewable energy company needs to calculate the total energy capacity of all solar panels installed on a site. The custom parent object, Solar_Array__c, is currently connected to the custom child object, Solar_Panel__c, via a Lookup relationship field. The administrator attempts to create a Roll-Up Summary field on Solar_Array__c to aggregate the total wattage, but the Roll-Up Summary field type is unavailable. What configuration requirement must be met to allow the creation of the Roll-Up Summary field on Solar_Array__c?
- Populate the Solar_Array__c lookup field on all existing Solar_Panel__c records, and convert the lookup relationship field to a master-detail relationship.Answer
- BEnable the summary aggregation property directly on the existing lookup field properties without altering the relationship type.
- CSet the Organization-Wide Default (OWD) sharing setting of the Solar_Panel__c object to Controlled by Parent while keeping the lookup relationship.
- DDelete all parent Solar_Array__c records to clear relationship locks, convert the relationship to master-detail, and restore the parent records from the Recycle Bin.
Answer
Populate the Solar_Array__c lookup field on all existing Solar_Panel__c records, and convert the lookup relationship field to a master-detail relationship.
Native declarative Roll-Up Summary fields require a Master-Detail relationship between the parent and child objects. To convert an existing Lookup field to a Master-Detail field, every existing child record must have a valid parent reference populated in the lookup field.
Step-by-Step Solution
Key Concept
Converting Lookup Relationships to Master-Detail Relationships for Roll-Up Summaries