My append query gives me key violations

[Guest]

I have created a student database that contains several tables. Two tables
are relevent to our students where the first holds personal information on
the student and the second contains information about student courses. As
students leave our program, I move the information from both tables to an
archive table. After the student information has been archived, I delete the
information from the original student tables. However, I want to be able to
reuse student ID numbers that are deleted from both tables. I have tried
several times to append the deleted numbers back to the original student
table and I keep getting the key violations window. Am I correct in assuming
it is possible to reuse these numbers? Do you have any suggestions on why the
program won't allow me to append these numbers? I read your suggestions on
why the violations window appears, but none of these appear to be my problem.
I could certainly use some help with this. Thanks in advance!

 

[Guest]

First your should just flag the records for archive instead of moving them.
Add a field named Archive - Yes/No.

You probably can reuse the numbers if you do a Compact and Repair from TOOLS
- Database Utilities.

 

[Guest]

Thanks! That was the general direction I needed.