HELP! Merging Two DataBases

[EliteDesk@aol.com]

I have two order databases, Access 2000, both with tblCustomers and field Job# (autonumber) as pk. Datebase1 started with Job# 5000, and database2 started with Job# 100001. The problem is database1 in now at Job# 100091, thus creating duplicate Job#'s. I need to merge the two databases which I now know I should of done in the first place. Can this be done, because of the autonumber? I need to be able to continue with the autonumber too, after the merge. Thanks in advance! Cathi

 

[EliteDesk@aol.com]

Thanks

I guess I was making this way too hard. You make it sound so easy. Thank you! Cathi