Does anybody know a quick way to number all of my records in newly imported database?
Add a number field and do in that field a formula fill with
seq()
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.
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