append query

[Professional_in_need_of help]

I have 2 tables. (Table1 and Table2). I want to append on piece of data
(Data1) from Table1 to Table2. This append query is ran everytime I open a
form. I only want records that have not been added to Table2 yet. So only
new records.

Please help.

 

[Klatuu]

Make the record source for your form a query with a Where clause something
like:

SELECT * FROM Table1 WHERE Data1 NOT IN (SELECT Data1 FROM Table2);

Depending on table size, it may not be fast to open.

What you are doing makes me suspicious of your database design. It isn't a
normal thing to do. It appears to be violating the redundancy rule.