FMP8 Adv, WinXP

I need to create a new ID field (number, auto enter serial) in an existing table but the table already contains more than 4000 records. The current ID field in this inherited file is based on a name (text) – not number, auto enter). How do I enter the new IDs using a command (or script?) so that every record will have a new/unique/sequence number ID in the field? I only need to do this once in order to place a new ID in each record. I’ve read info about serial auto enter IDs, but I can’t find anything on how to input the serial IDs in an already existing table with records. TIA lpm

Go to a layout that displays the field that you want the unique id to be in.

Show the records that require to be changed and go to the first record.

Put your cursor in that field

Record pull down menu will give you 'replace field contents' and there you will Find the options that will enable you to enter a unique numeric id in each record.

Do a backup of your file before you attempt this as it is not un-doable

HTH

Phil

Thank you, that worked great!