adding numbers into a databse automatic

[raymate]

Have an old FM file that has 880 records in it, we have added a serial number field and asked it to start counting from 881 and this is does with any new records.

What we would like it to be able to put the serial number into the old records, of course old records have nothing in the serial field.

Apart from typing in 1-880 into every record, could it be done some how I assume changing the field from a serial to something else, add the numbers then turning back on the serial number option.

R

[Lee Smith]

Show all records (Cmd J)

put your cursor in the serial number field

Main Menu >> Records >> Replace Field Contents

You will get a Dialog Box

Second Choice Serial Numbers. Put [color:red]1 in the first field, Click [color:red]Replace

HTH

Lee

[raymate]

OMG, that was so easy... never thought to look there, I was dreaming up some sort of calc to do it...

Thank you..... :)