I would create a new field in the customer table to hold the new customer number. I would then leave the oldcustomer number as the PK for the customer table and let the new customer number be a look up field in the customer table. This will prevent any need to touch any of the other tables at all.