I have the following scenario:
I have one SharePoint List - List_A and one SharePoint form - Form_A
List_A has two columns (ConfigItem and ConfigValue) and it contain a few configuration settings.
In my Form_A, it is basically a form library whereby Info-Path form was stored. When a user create a new form, the form will retrieve the current ConfigValue (from List_A) based on ConfigTitle = 'ProjectA_ID' and display to the user using the form's text field.
When the user submit the form, that number will be recorded into the form and a workflow (or something else - using InfoPath form rules?) will update the ConfigValue (in List_A) by adding 1 to it. So if the user create the form see a value 5, then when user submit the form, the ConfigValue will become 6.
So, my question is how should I proceed to create such solution for the above scenario?