Serial number increment based on other field value

[usit86]

Is it possible to have an auto entered serial increment based on the value of another field?

 

That is

IF FIELD_A = "INVOICE" ; INCREMENT SERIAL_A

IF FIELD_A = "PRO-FORMA" ; INCREMENT SERIAL_B.

 

Hope this is clear.

 

Thank you

[aaa]

You can make your field auto enter calculating value.

Create two global fields Gl_Field1="INVOICE"

Gl_Field2="PRO-FORMA". Create relations from this fields to Field_A.Sort your related records by Record_Id.Then your calculation will be such as:

Case(FIELD_A="INVOICE",RELATION1::SERIAL_A+?????,RELATION2::SERIAL_B+???)