Mutating Table - Update Same Table
Hello,
I have case where I have a mutating table because of a trigger. Here is the case:
One record gets updated. Related records should also be updated with the same information. I create a trigger on the after update action, to update the rows in the table. But when I do this, I get the mutating table (very obvious why).
I have seen a lot of examples on how to avoid mutating tables, but all the examples I find have to do with several tables. How do I do this with one table updating itself?
Thanks, Charlie.