Skip to Main Content

How to avoid Table mutating

User_JFC05Nov 9 2022

I have a table where key members and their roles are stored for a particular project.
For example when a user enters a key member and assign him Project Manager Role, the same key member cannot be a PM Proxy. If I try to do the check in a trigger I will have to select the key members and their roles to make a comparison to see if the same key member is already a project manager. If I do that I will get table mutating error. How can I avoid that and yet make a select on that table?
Your help is greatly appreacitated

Post Details
Added on Nov 9 2022