If the tables [In Debt] and [No Answer] are only being populated by transferring records from the table [Done], then change the data type of ID in those two tables to numeric - long integer , so that the value of ID is retained when the records are moved.

John