I have 1800 records and I have been asked to assign each record a serial #.

How would I start from # 1 and assign all 1800 records a serial number in increments of 1 automatically without generating a new record?

Thanks

Hi Jscott

Put your cursor in the field that will hold your serial No (create one if you have to) and go to the records pull down menu. There you will find a replace option , one variation of which is to replace with a serial number.

Regards

Phil

Make sure that you are on a layout showing the field in question. Go to the records menu and click Show all records (if it is not grayed out in which case you already are showing all records). Select the field in question go to the Records menu and select Replace Field Contents. One of the options that comes up is replace with serial number.