Ask Your Question
0

How can I format a column of numbers to be serialized?

asked 2018-03-09 20:47:59 +0100

Dafydd gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-03-09 21:15:39 +0100

Ratslinger gravatar image

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.

edit flag offensive delete link more

Comments

Thank You, that works well.

Dafydd gravatar imageDafydd ( 2018-03-10 17:19:57 +0100 )edit

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.

Ratslinger gravatar imageRatslinger ( 2018-03-10 17:24:04 +0100 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2018-03-09 20:47:59 +0100

Seen: 71 times

Last updated: Mar 09 '18