hello can you help please.
I have 2 tables with this structure:
- company_id (key) ( unique id )
-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?