Leb i Sol Posted May 22, 2003 Posted May 22, 2003 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 Posted May 22, 2003 Posted May 22, 2003 You can show all records, sort them accordingly & then do a replace, serial number, update serial# definition.
Leb i Sol Posted May 22, 2003 Author Posted May 22, 2003 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!
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now