>>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.
>
>Craig is correct: the actual value shouldn't matter, just that it's unique. Besides, imagine this scenario: you add a record, assigning the next available ID to it (let's say it's 5). Then another user adds a record, getting 6 for the ID. Then you TABLEREVERT(). What should the next available ID be? Should it be 5? If so, then what happens when someone uses it? The next one can't be 6 since that's already been used.
>
>The autoincrement feature isn't intended to be a completely sequential value without holes in the sequence. In addition to reverts, when you delete records and then pack the table, the ID values aren't renumbered, so there will be holes in the sequence in this case as well.
>
>Doug
Doug your example was correct,but if i want to assign check number and print the checks i can't have a break in numbers.then i have to void the check.that's what i want to avoid by autonumber.
another question is
Can i force the autonumber to generate when i click Save. I think that would solve the problem.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only