Serial Numbers

[Ben Ball]

I have many records in a table and wish to give them all a serial number, How can I select them all, give them all a sequential number,say starting with DN0001 then continue on as normal with the next number etc?

Any ideas?

[Lee Smith]

If you haven't already made a field for it, do that first.

Next, be sure you have all records in your found set (i.e. Find all records).

Next, in Browse Mode, put your curser into the New Serial field

Then to to Main Menu >> Records >> Replace Contents

This will bring up a dialog box, and you enter what the number is suppose to start with, (i.e. 0001, and the increment (defaults to 1)).

HTH

Lee

[Ben Ball]

Fantastic, as easy as that.

[Lee Smith]

Oops,

Except I forgot to mention that you then need to go back into define fields and make the New field a auto enter serial number.

Highlight the field, hit the Option button, and the choose Auto Enter "Serial". The Box for start should now have the next serial number to be used in it.

HTH

Lee