Hi!

Use Customer Exclusive
Alter Table Customer Alter Column CustomerID i AutoInc NextValue 1 Step 1

The above command should do the trick as long as the customerid column is the autoinc column in the customer.dbf file and you have opened the customer dbf exclusively.

Sarosh

>Using VFP8, I would think that at least ZAP should reset the Autoincrement column. did I miss anything? or autoincrement is forever.
>
>Mo