So in my application companies have a live profile, they are given a form where they can change this profile, but before it goes live we approve it internally.
I've created a "session" table of each table associated with a company. When the company fills out a form it saves to the session table. When we approve it, it updates the live table.
Companies can have multiple contacts, stored in one table with multiple entries per company, each with a unique contact id and the associated company id.
Would there be a way to update multiple contacts in the live table at once?