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