Serial Increment by Letter

[Nestor]

Is there way to create a script that will increment the serial by a letter. If i have an Item CRM001, and i hit a script button can i make it so that it assigns a CRM001A, then if i hit it again it will assign a new serial number of CRM001B?

Thanks in advance.

[comment]

And when you get to CRM001Z?

[Nestor]

It won't. I mainly want to use this type of serial for Revisions of CRM001. There can only be about 15 at the most.

[comment]

An easy way to do this would be to have a field with the (original) item code, a field for the revision number, and a calculation field =

ItemCode & Middle ( "ABCDEFGHIJKLMNOPQRSTUVWXYZ" ; Revision# ; Revision# > 0 )

[Nestor]

I tried, but i can't make it work.

Any way you can build something really fast so i can see how you apply the script?

Thanks in advance..

[comment]

Something like this?

BTW, I wouldn't increase the revision # by clicking a button. Instead, I'd make a related table with a permanent record for each revision.

Revision.fp7.zip

[Nestor]

THANKS.....

[Nestor]

Ok, so the revision worked, however now I'm trying to do the following.

I have a work order table, and for 1 work order record i can have multiple "Products".

for Product I can have "New Products" or "revision to Products".

What i have to figure out is when i click on New products i want the product Number to generate based on 2 fields. Each field with a drop down list.

Field # 1 ---Product Line

Field # 2 ---category

and a numerical value per product line+category.

For example if i select

Miami Ink as the product Line and for the category is Mens. well the code for Miami Ink is "MI" and the code for Mens Category is "M".

I want my Product Number to be "MIM" and then the next numerical value in the same product Number.

so if the last one that was created for MIM was

MIM0017, i want my new product Number to be MIM0018-A (the -A) is always given to the first Product Number (REVISION would have -B,-C and son on-which i still need to figure out how to do this.

BUT if for some reason i pick the category Jrs (the code is J) my product number would be MIJ0200-A. I want my numbering to stay consistan to the Product Line and category. Hope this makes sense.

Any Ideas how i can do this?

So far i have a Work Order table, a Product Category Table with all codes for Product LIne and Categories, and i have a empty Product Table.

I figure i can make a script that as soon as i create a new record it will prompt me to select the product line and Category, but after that i have no idea what to do.