>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.
This is by design. Even in SQL databases this is true. Once you have the number generated, you can not revert it. If you need this to happen, then you need to create a view or remote view and do not make the autonumber field updatable. That way, the autonumber will only be generated when you execute a TABLEUPDATE(). Once you issue the TABLEUPDATE(), the autonumber is then generated. At this point, again, you can not revert the autonumber.
Mark McCasland
Midlothian, TX USA