Need to merge 2 identical databases w/different data - help!

[toenailbrain]

I created an Access database with 3 tables. They all have an autonumber field, and each has a reference to the other tables. 2 of the tables can have multiples.

I gave copies of the database to two people for input, and now I have to merge the two. I thought a simple import would work, but that gives me duplicates of the tables instead of combining the records.

Would an append query work for this, and if so how? I can't seem to make it happen.

The tables in the 2 databases have identical structure but different entries and record numbers.

Thanks.

 

[cogent1]

Append queries should work, so why isn't it happening? The situation can't be as straightforward as you suggest, perhaps. Zip up the files and email them to me and I'll see if I can solve your problem.