A Salesforce administrator needs to establish a relationship between a custom object named Equipment_Maintenance__c and the standard Asset object. The business requirement dictates that if an Asset record is deleted, all associated Equipment_Maintenance__c records must be automatically deleted as well. Which relationship type should the administrator create on the Equipment_Maintenance__c object?
- A Master-Detail relationship with Asset as the master objectAnswer
- BA Lookup relationship with Asset as the lookup target
- CA Lookup relationship combined with a Roll-Up Summary field on Asset
- DA Hierarchical relationship referencing the Asset object
Answer
A Master-Detail relationship with Asset as the master object
Creating a Master-Detail relationship on the custom child object with the parent object as the master enforces cascading deletion, ensuring that deleting the parent automatically removes all related child records.
Step-by-Step Solution
Key Concept
Master-Detail Cascading Deletion