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 issues). 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!!