Serialize All Existing Records

[life036]

Sorry, I think I posted this in the wrong forum earlier -

Can anyone help me with serializing all my existing records? I created a field, and set it to auto-enter serial numbers starting with 000001, but unfortunately this doesn't work for existing records.

Is there a way to "trigger" the auto-enter serial to do it's magic on all existing records?

Thanks!

Chris

[Raybaudi]

Hi

1) make a backup of your DB

2) show all records of your DB

3) place the cursor inside your serial field

4) from menu Records >> Replace Field contents... >> Replace with serial numbers

initial value: 000001

increment by: 1

check the box: Update serial number in Entry Option

... and press "Replace"

[life036]

Great! Thanks Daniele!