Query to update table based on missing entries

[togo]

Hi, I have a database where we have people doing reports online and offline. When they return from offline status they have been working on a copy of the back end and their report has gone there into three different tables. When they reconnect to the network drive, I was hoping to run a query to append this new information to the back end and then use SyncToy through a hyperlink to replace their local fake back end with the one on the network drive as an update function for next time they go offline.



It looks like a union query could do the trick. Anyone have a basic example?

Essentially a client file table contains the job number, address, client name, contact and job description
A report subtable contains report specific information, controlled by job number and report number
An items subtable controlled by job number, report number and item number.

Thanks for any help.

[togo]

i was thinking of something like this:

INSERT INTO table2
(jobnumber, reportnumber)
SELECT table1.jobnumber, table1.reportnumber
FROM table1
WHERE table1.jobnumber <> table2.jobnumber AND table1.reportnumber <> table2.reportnumber;

you think this code wil work the way I want it