I need help!!

I have two databases, db1 and db2.

There are two tabels in db2, tbl1 and tbl2.

tbl1 is a linked table from db1 and has an autonumber primary key.

I created a number field in tbl2 and related the key to this number field and appended all the records from tbl1 to tbl2.

I now need to continually update the data in tbl2, which I know how to do using an update query.

But, I also need to append each new record from tbl1 to tbl2.

Heres my ?.

How do I append the new records in tbl1 to tbl2. If I allow duplicates in the num field in tbl2, it re-appends all the records that i already have, If I do not allow duplicates, I get an error message, key violation, because it would have to duplicate to append.

the db's are in access97.

I welcome any solutions including vb codeing.

THANKS