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.

And when you get to CRM001Z?

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.

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 )

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..

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

THANKS.....

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.