I have 2 tables. A company table and a company personnel table.
The company personnel table contains a foreign key to the company table.
I want to replicate the records entered in these 2 tables, into 2 other tables for a different company.
As each record is entered, I can trigger an append query to update the second set of tables.
In the append for Company, I would leave out the ID which is an autonumber field.
Question 1. Could I check that the company I am appending is not already in the tables I am appending to and if it is update it rather than create a new record.
I would expect the Company Name to be unique.