Hi guys,

I have a problem where I have two databases with similar table structures
that need to be combined. I have run a File - Get External Data - Link
function from one of the dbs and now have two copies of each table. The
original one from within my db and a table with a '1' at the end as the one
linked from the second db.

Makes sense so far... The problem I have is that one of my tables has got a
field called "ID" set as the key. The data type of this field is "Number".
When I run my append query I am getting errors saying there is a key
violation. I dont have this problem in tables where the field data type is
set to "Auto Number". In the two tables, the ID entries both start from 1 but
have differend details so I can't just use the table with more entries in my
final database.

Any advice on this one? Does anybody here have the no doubt guru-ish level
of knwledge that I'm lacking to advise me on how to combine the contents of
these two tables?

Thanks very much,

cheers
Matt