Hello Everyone,

I'm working a form that had a Stored procedure and a drop-down field.

This is the scenario, I'd like to do in Stored procedure.

1. The incremental value "000" not be changed even the drop down value is changed.

Scenario: I select a value @DropDown field: WKI value and Stored the value in Stored procedure and shows the final value in a single field like this "CWPO-2021-08-WKI-001", before I submit the form I change the value of the @DropDown field to IPC because I selected a wrong value, the final value in a single field after I change the value of @DropDown field must like this "CWPO-2021-08-IPC-001", the incremental value must not be change in any selected value of @DropDown field.

2. The incremental value must reset to beginning if the month change and year change.

3. The next incremental value is generated if a new form is started by a user and a user select a value @DropDown field, even the user changes the value of @DropDown field, the incremental value must not be changed if the form is not submitted.

It is possible to do this Stored procedure?

Hoping you can help me.

Cheers!