Hi,

My client wishes to delete all previous record in the database....The last record number is 241 which corresponds to the last order made..Is there a way to reset the autonumber default value back to 1 once I delete all the records and start with a new record?

The field name is OrderNum(data type is: autonumber).

Hope you get my point....

Greg