When formatting a database (inventory), I want the database to automatically assign the entry the next number in order. In MSW 6.0, which is what I have been using, this can be done when formatting the numbers in a column and you can assign whatever starting number you wish. I am missing this, can’t find it or is this option not there. If not there, would be a very useful feature. I maintain dozens of inventory databases this way.
Hello,
When designing a Table, you can set one numeric field to increment from the previous by setting AutoValue property to Yes. This field will also automatically become part of the Primary key.
If that is not what you are looking for, the other option is to write a macro to get highest value already used & increment that.
To my knowledge there is no other built in method in LO Base. Depending upon the database being used, you may be able to do it using a procedure although it is typically recommended to stay away from these.
Thank You, that works well.
You’re welcome.
If this answers your question please tick the 
(upper left area of answer). It helps others to know there was an accepted answer.