Allow users to replace a value in multiple rows

[Ami]

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?

[Marc_Dillon]

Update a value based on another table's column Questions

I’m trying to update the ID number for a person based on the ID entered on another table I have a table named attendance with the data: [key, [person], [meal1], [meal2], [meal3], [documentid]) I have another table called people with the data [key], [name], [documentid] I have a database of 5,000 people but for a 30% of them the [documentid] for me is unknown (null) I want to update the value in people.[key].[documentid] based on the attendance table Currently in the table attendance, when th…

Change value of a column in a table when form is submitted in another table Questions

I am creating a basic CRM for internal use. I have a table “organizations”, containing the columns [organization name], [stage], plus others which are not important Than I have a table “projects”, containing the columns [organization name], plus others plus others which are not important The column [stage] in table “organizations” is displayed as dropdown with fixed predefined values: Cold Lead Contacted Interested Call Scheduled Pilot Project Project What I would like is that whenever…