Change rows in tables

hello can you help please.
I have 2 tables with this structure:

Company table

  • company_id (key) ( unique id )
  • id_people

People table
-id_people (key) ( unique id )

I have an action on the company table to generate a copy of the row. but I want the person in the people table to change the company_id to this new row.
you would have to look in the people table for the person with the old company_id and change to the new company id
I don’t know if I made myself understood. How can I maybe do this with an action?

How would the app know which old id to replace with which new id though?

1 Like

Hi Marc I have the id_people in both tables and its ref