A Salesforce administrator at a marine conservation non-profit is designing a custom data model to track scientific research trips using a custom object named Research Expedition and associated findings using a custom object named Specimen Observation. The organization requires that deleting a Research Expedition record automatically deletes all related Specimen Observation records. Additionally, leadership needs a field on the Research Expedition object that automatically calculates the total number of related Specimen Observation records. Which relationship configuration should the administrator implement to meet these business requirements?
- Create a Master-Detail relationship field on the Specimen Observation object pointing to Research Expedition, and create a Roll-Up Summary field on the Research Expedition object.Answer
- BCreate a Lookup relationship field on the Specimen Observation object pointing to Research Expedition, and create a Roll-Up Summary field on the Research Expedition object.
- CCreate a Master-Detail relationship field on the Research Expedition object pointing to Specimen Observation, and configure cascading delete on the parent object.
- DCreate a Lookup relationship field on the Specimen Observation object pointing to Research Expedition, and assign picklist values via Record Types to manage deletion access.
Answer
Create a Master-Detail relationship field on the Specimen Observation object pointing to Research Expedition, and create a Roll-Up Summary field on the Research Expedition object.
Creating a Master-Detail relationship field on the child object (Specimen Observation) pointing to the parent object (Research Expedition) satisfies both requirements: deleting a Research Expedition record automatically cascades and deletes all related Specimen Observation records, and native Roll-Up Summary fields can be created on the master object to calculate the total observation count.
Step-by-Step Solution
Key Concept
Master-Detail Relationship Behavior and Roll-Up Summary Fields
Estimated Time:1m 30s