Hi all,

I've managed to successfully copy an existing record within a report by using a custom button (code below). I am struggling with changing the revision number of the new record. Currently the code below highlighted in yellow successfully copies the revision number of the existing record, but I would like to change the revision number to the next corresponding letter. e.g. if the existing revision number is 'A' I would like to change the new record revision number to 'B'.

Any ideas how I can go about doing the within the function below.

void ChangeRevision(Design_Change_Review_DCR Revision, string DCRTitle, string RevisionNo, bool Superseded, int DCRNo, string DCRStatus, int InternalChangeProposalNumber, list ProjectWorkPackage, string ClientChangeProposalNumber)

{

Revision.Superseded=True;

insert into Design_Change_Review_DCR

[

Added_User=zoho.loginuser

DCR_Title=DCRTitle

Superseded=false

DCR_No=DCRNo

Revision_No=RevisionNo

DCR_Date=zoho.currentdate

Action_Status="In Progress"

Submitted_Date=null

Superseded=false

DCR_Status=DCRStatus

Internal_Change_Proposal_No=InternalChangeProposalNumber

Project_Work_Package=ProjectWorkPackage

Client_Change_Proposal_No=ClientChangeProposalNumber

]

}