hello can you help please.
I have 2 tables with this structure:
Company table
People table
-id_people (key) ( unique id )
-company_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?
https://community.appsheet.com/search?q=reference%20actions%20%23ask
How would the app know which old id to replace with which new id though?
Hi Marc I have the id_people in both tables and its ref
User | Count |
---|---|
41 | |
28 | |
24 | |
24 | |
13 |