importing/copying Autonumber data

[TimSullivan]

Hello
I have a two seperate databases. Both databases have the
same field names. However the data in each of them is
different. Database "A" has a field called "job number"
it is a autonumber field starting at number 1 and it has a
couple of thousand records. Database "B" has the
same "Job number" field and is also a autonumber field.
It starts at 10,000 and also has several thousand records.

I want to copy a portion of database "B" records into
database "A" and keep the same Job Number.
When I try to copy data from "B" into "A" new Job numbers
are assigned and I can not have that.
Linkings tables won't work as the end users have the
databases on their laptops and are not connected
Any ideas????
Tim

 

[Douglas J. Steele]

You should be able to append the data from Table 2, autonumber and all, to
Table 1. You'll run into a problem, of course, if the autonumber value is
already in use.