Script Steps to update all related records?
I have a table Estimate with a field called estimate_parent_id, and I did a self related table called Estimate 2 based on that field (to keep track ofthe number of duplicates that exist for each parent Estimate).
I want to create a script that runs everytime a duplicate of the parent is created that goes and adds 1 to the "duplicate counter" field in all related parent records to the current count value. Same thing with the deletion of a duplicate (finds all related and removes 1 from the duplicate count in all related records).
Does anyone know the proper script steps to update all found or related records? I'd rather not use a loop if possible.