Allow users to replace a value in multiple rows

Lets say i have a parent and a child table. My user wishes to change a value in the child table based on a new value from the parent table. Simply put, allow my user to run a sql query like action to find where a certain value is and then replace all with a new value.

I have an employee table in which i have employees who work in a main site, i also have managers. Each manager manages multiple sites. In my sites table i have list of sites and their managers.

Now a new managet is added in the employee table and he is replacing a current manager.
I want to change in my sites table all the sites managers where the previous manager was with the new manager. Could this be done in the user side in one action?

1 Like