Just call your stored procedure when you need to assign a unique value to the form...
i.e don't have the data connection called on open and instead assign it as a submit rule....call the web service to invoke the stored proc, return the value and assign to your form on submit preserving the sequential numbering.