An administrator at a higher education institution is building a custom data model to manage campus facilities. The institution requires that when a Venue custom object record is deleted, all associated Event Reservation custom object records are automatically deleted from the system as well. Which field configuration should the administrator implement on the Event Reservation object to support this requirement?
- Create a Master-Detail relationship field referencing the Venue object.Answer
- BCreate a Lookup relationship field referencing the Venue object.
- CCreate a Master-Detail relationship field on the Venue object referencing the Event Reservation object.
- DCreate a Lookup relationship field with roll-up summary capability on the Event Reservation object.
Answer
The administrator should create a Master-Detail relationship field on the Event Reservation custom object that references the Venue custom object.
Creating a Master-Detail relationship field on the Event Reservation object pointing to the Venue object establishes Venue as the master and Event Reservation as the detail record. In a Master-Detail relationship, deleting the master record automatically cascades and deletes all related detail records, satisfying the requirement.
Step-by-Step Solution
Key Concept
Master-Detail Relationship Cascade Deletion