I am saving a record to a database on SQL server 2k that has a field 'id' -- it is an autonumbered/identity field and thus auto-increments as necessary when saving records.At any rate, this is the ...

But if you want your autonumber field to start at 1 then you could just delete your current autonumber field and then put it back in again. That renumbered the autonumber field for me.