Define and Update new Serial for existing records

[Leb i Sol]

Hello Peoople!

I am hopeing some one can help out....perhaps a script guru would see a short way out of this. I have 700+ records that need a serial number generated and updated accordingly. I have a field "SerialNo" defined as serial auto-enter and increment in format ABC0001 increment by 1. This works great for the new records created but I need this field to be updated for all the records each record would reflect:

eg.

record1 SerialNo:abc0001

record2 SerialNo:abc0002

......

Any thoughts?

Thank you for the help!

[cjaeger]

You can show all records, sort them accordingly & then do a replace, serial number, update serial# definition.

[Leb i Sol]

thank you....and I even used this "function" before why oh why did I not think of it!

worked like a dream!

her cjager fiel danke zu hilfen

ok...my german is not that great alta but THANK YOU!