>Hello
>
>Just trying out the Vpf8 beta,in my table i set logno as autoinc field and created a form using wizard for that table and when i click add the autonumber increments,but after clicking revert and then again click add the number doesn't seem to get reverted.it just keeps incrementing.
>
>Is this by design. if so i'm very disappointed.
>
>any workaround for this.

One more point. What would happen if 2 records are added close together? The first has ID 3 and the second has ID 4. Autonumber now sits at 4. The first is reverted and the second one is saved. If you had what you wanted, the autonumber would be reverted to 3, but the second record now has the number after the current autonumber count. The next record addition now creates a duplicate number.

One thing to note is this is NOT a pure PK generator. It is only an autonumbering feature. The autonumber seed value can be reset at anytime so duplicate values can be generated. The only way to enforce PK values is still through creating a PK index.