append query

  • Thread starter Thread starter Professional_in_need_of help
  • Start date Start date
P

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.
 
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.
 
Back
Top