Autonumber

[Guest]

How to prevent loss in autonumber?
When i escape a new developed autonumber, i do lost the record; for a
receipt id
i can't allow myself to loose record.

 

[Ken Snell \(MVP\)]

Then do not use Autonumber for numbers that must remain completely
sequential without gaps. Autonumber is intended as an "under the cover"
primary key value that shouldn't be displayed to users and shouldn't have
any meaningful value. Use a different field and then use programming to
increment this new field's value when you start / save a new record.

 

[Joseph Meehan]

How to prevent loss in autonumber?
When i escape a new developed autonumber, i do lost the record; for a
receipt id
i can't allow myself to loose record.

I suggest you may not want to use Autonumber for that use. Autonumbers are
designed to provide unique numbers. It in not designed to provide numbers
in order and for a number of reasons may not do so. As a result using them
in any application where the user sees the numbers is likely to end up with
confusion.

There are other ways of providing the numbers you want depending on the
particual application.