First off, you've guys have helped me in the past so I would like to say thanks in advanced.

I've run into a little snag. Here is what I need to happen in the database. I've created a script that will make a duplicate of all of the information contained in a form I've built. The script also copies the automated serial number so it doesn't have to be reentered.

I would like to be able to add a revision letter to the now duplicated record, example: Serial Number 1901, revision A. If I need to make an additional revision to information in that record I would like to be able to make another duplicate and issue a revision B status. Right now it is a manual process, but I would like for it to be automated.

I've gone through several If and Case scripts unsuccessfully. I know I am missing something simple.

Your help or suggestions would be greatly appreciated. I am completely tapped at this point.

Cheers,

Kaiden

It's not very clear how you would want it to work, Kaiden.

Do you want the users to be able to 'clone' any record and have the database automatically determine what revision suffix to append to the serial number? Or will they only ever 'clone' the most recent revision? Or do you want the database to always force the clone to be the most recent revision even if the user tries to clone an earlier revision? What happens when the current revision is the 26th and is marked as revision "Z" - where do you go from there?

I want the user to be able to clone any record and have the database automatically determine the revision suffix. The revisions will only go from A to D.

I took the most straightforward approach so you'll need to let me know if there is something I missed from your description. I thought it best to describe the technique with an example. Enjoy!

AtoD.FP5.zip

John,

Thank you very much. The script worked prefectly.

Cheers,

Kaiden