I have a problem. I have a Purchase Order database where sometimes we have to revise a PO and save a copy of the old record. The new record would have the same auto-serial number and a number added to another field called "Revision Num". Is there a way to duplicate a record, give it the same auto-serial number as the old, add a number to the "Revision Num" field in the new record, and check off a box in the old record called "Revised" so it can be filtered out in general searches and reports? It seems really complicated but I don't know any other way. Thanks.

Using ScriptMaker

>Is there a way to

>duplicate a record,

Duplicate record/request

>give it the same auto-serial number as the old,

you may need a second field into which you set the original a-sn.

>add a number to the

>"Revision Num" field in the new record,

if there is a number already in the field, SetField ["Revision Number" +1], otherwise use a calculation

>and check off a box in the old record called

>"Revised" so it can be filtered out in general searches and reports?

again a SetField can add a data bit such as "0".

You may need to design a subscript. You will know.