L
Lee T.
Unfortunately, that is the way autonumber was designed to
work. About the only thing you can do is to not use
autonumber but do it yourself with a unique index on the
field and then when adding a new field check for the max
of the field and increment by one.
work. About the only thing you can do is to not use
autonumber but do it yourself with a unique index on the
field and then when adding a new field check for the max
of the field and increment by one.