function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
RJ12RJ12 

Trigger to delete multiple child object records when a parent record is deleted.

I have a parent object A and two child objects X, Y. Both X, Y have lookup relation to object A.

I'm looking for a trigger to delete related records in both X, Y objects when a parent record in object A is deleted.

Sampath SuranjiSampath Suranji
Hi ,
If you use Master detail relationship other than the lookup, when you deleting parent, child records automatically get deleted.
otherwise you can try below trigger  
trigger deleteRelatedChilds on ObjectA (before delete) {
    List<Id> ObjectAIds = new List<id>();
    for (ObjectA objAcc: System.Trigger.old) {
        ObjectAIds.add(objAcc.id);
        
    }
    List <X__C> xList=[select name from X__C where ObjectA__C in :accountIds] ;
    List <Y__C> yList=[select id from Y__C where ObjectA__C in :accountIds];
     
    delete xList;
    delete yList;

}

Best regards
​