InfoPath Dev

I follow you, but then how do I run that query at submit time and insert the field value into my form document number?

I suppose it is possible for two people to submit simultaneously, but wouldn't it be entirely unlikely to have the transactions at the same microsecond? Or am I being naive? Either case I don't know how to code the execution of the SPROC, then retrieve the value, then place into document number field at submit in jscript, so that when the record ...

Thanks for the reply, but being a complete newbie to Infopath I am unsure where to start. Also, numbering gaps are not a horrible thing in this case, and if the process can be done at submission, then it would be safe to say that if the form does not submit, then the highest number in the table is still not used. Still searching for a solution.

I am using info path as a form solution for one of my clients. The data source is MS SQL and has a primary field for document number. The script defaulted to jscript, so I am stuck using jscript for the scripting language. I am looking for a solution to increment to the next highest document number on form submit. I do have a stored ...