Managing autonumbers

[Laurel]

I have a table of students that uses autonumbers for IDs. Along the way a
mirror-image table in a mirror-image database was populated with different
students, but with some duplicate IDs. That is, the students in each
database are different, but some of them have the same IDs. Now the request
has been made to move the students from the second database into the main
database. Any ideas about how I adjust the IDs? Needless to say, these IDs
are found in other tables in each database.

TIA
LAS

 

[Rick Brandt]

I have a table of students that uses autonumbers for IDs. Along the way
a mirror-image table in a mirror-image database was populated with
different students, but with some duplicate IDs. That is, the students
in each database are different, but some of them have the same IDs. Now
the request has been made to move the students from the second database
into the main database. Any ideas about how I adjust the IDs? Needless
to say, these IDs are found in other tables in each database.

TIA
LAS

In a copy of one db change the AutoNumbers to Long Integers. Making sure
that cascade update is turned on update the numbers to a range that is
NOT included in the other database. The cascade should propagate the
change to all related records. Then import the data into the other db.