Set field value to next alphabetical order by lookup

HCL Domino Domino Forum
1

I have a form with code and second one alphacode. alpha code has keyword alpha list from A-Z.

I want to set alphacode default to A then when user create another form with same Code and alphacode should change to next alpha order which is B then C so on. My code below give me error “Field name requires as value”

ac:=@DbColumn(“”:“NoCache”;“”:“”;“AlCode”;1);

@If(AlphaCode=“” & @Right(ac;1)=“A”;@SetField(AlphaCode;“B”);

@Right(ac;1)=“B”;@SetField(AlphaCode;“C”);

@Right(ac;1)=“C”;@SetField(AlphaCode;“D”);

@Right(ac;1)=“D”;@SetField(AlphaCode;“E”);“”)

Please help.

amp