Numbering records in a database


#1

Does anybody know a quick way to number all of my records in newly imported database?


#2

Add a number field and do in that field a formula fill with

seq()

#3

Kurt’s suggestion will work fine, but if you want to do it without programming or a formula, open the Morph Field dialog, then change the pop-up menu from Start with Field to Start with Sequence.


#4

Or, use a text field and morph data using the padzero( function:

padzero(seq(),4) will fill a field with:

0001
0002
0003
0004
0005
etc

“4” is the number of digits to pad to.

chris