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
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:
"4" is the number of digits to pad to.