Hi friends,
I have a problem with getting this InfoPath form to work. Here is the story behind what I need.
I have a project number and an issue number. A project number is unique to a project. An issue number is a unique value for an issue of the project. (1 project can have many issue numbers). So a project number would look like this; 100. Then an issue number for that project would look like this; 100.1, or 100.2 for example.
What I need is the issue number to increment every time someone selects a project number from a form. So if a user selects project number 100, and the current issue is 100.1, it needs to increment it by one to 100.2.
This information is read in from a form library within SharePoint. The structure of the form library looks something like this;
Form – title – project number – more attributes here – issue number
I currently have a data source that points to the Project number using a dropdown box. Then the issue number is a textbox, which needs to update automatically once the project number has been selected.
My current formula looks like this; max(@Project_Number[. = project_no])
This basically gets the project number from the form library as oppose to getting the incremented issue number.
Please advise many thanks in advance!!