AnsweredAssumed Answered

Script Steps to update all related records?

Question asked by timothy2k on Aug 13, 2009
Latest reply on Aug 13, 2009 by timothy2k


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.