records -> replace -> serial starting with 400
Hi thanks for the information.
But what it did is started the first record at number 400 and it increased it by 1. I guess I just need to go back and start it off at 1.
But for future reference if you were interested in starting off at the middle of the records then how would you solve this problem.
this will be a definitive solution...
1) Go to Fields definition and set the option of that field to autoenter a serial number starting from 1
2) In Browse Mode Show All Records ( eventually Sort them, if you want )
3) Put the cursor inside that field
4) From the Menu Records do a Replace Field contents... >> Replace with serial numbers: Initial value 1 Increment by 1 and check the box "Update serial number in Entry Options.
This is all.
I forgot to mention that you have to search for records which don't have a number yet. Search for '='.
But now it is too late. Choose all records Ctrl-J and renumber from 1 as the other poster suggested.