Hi

I have a Customer table with the below fields.
CustID  [Autonumber][Primary key]
Name
Address

Sometime I want to archived the non active customer to another
Archived_Customer table where data can't be edit.

The problem is that if I archived the customer with the last CustID to the
Archived_Customer Table, the Customer table will create the new CustID that
could be duplicate to one of the non active customer in the Archived_Customer
table. This will cause Key violations when append to the Archived_Customer
later on.

Is there a way to fix this problem?
I am thinking of obtain the CustID from another table, eg CustID register.
so when ever a new customer ID create it will get the next available number
in the CustID Register table? But I don't know how to do this. Could you
please help.

Thank you very much
Hong