Convert the number field to Auto number field.

[joyo2003us]

How can I convert a number field to Auto number field, The sequence
numbers have some gaps. It is one time work. I made a mistake for my
system. I just try to fix it.

Thank you for your help.

joyo

 

[Douglas J. Steele]

You can't.

What you can do is add a new field and make it an AutoNumber, but you cannot
change a numeric field to an AutoNumber.

However, be aware that AutoNumbers are not guaranteed not to have gaps. If
the value of the field is important to you, it may not be a good idea to use
an AutoNumber. AutoNumber fields exist for one purpose only: to provide a
(practically guaranteed) unique value that can be used as a primary key.
323, 325, 327, 328 fills that purpose just as well as 1, 2, 3, 4.