I have a new Service DB with 6,000 new records. I was unhappy with the existing ID and want to use Capkurt's formula to reassign sn's to all records; and then begin auto-entering it. I cut and pasted the formula into a script. SN is a text field. But it keeps saying it can't find field '6' from the first line. Is it because I'm not actually in a record and it refers to CurrentRecordID? Is there a way to run a script through all my records and assign according to this formula?

I replaced all the the semi-colons with commas and it worked. I suppose it was because ... well, I don't know, but I now have unique SN's!

In some countries (esp in Europe), semi-colons are used in place of commas to separate the parameters within functions (this is to avoid confusion in countries where a comma is used as a decimal point). In the US and many other countries, commas are used in place of semi-colons as the standard. It sounds like you had a bit of cross-cultural 'translating' to do

Thanks for that info! I'll watch for those types of translations. If I hadn't re-read his previous formula, I probably wouldn't have figured it out ... since, although I'm studying like a fiend, I still haven't learned FM yet! Heck, I guess I probably never will be a master; when I see others with over 2,000 posts! I hope this made sense ... I've been up all night ... I have a presentation for Management at 8:00 a.m. and I'm NOT READY!