I have been working on an InfoPath form with a connection to SQL server. The standard SQL button options have the ability to create a new record. Great feature, but how do I add that to custom code? My submit button is doing a lot of stuff (like hiding sections, showing sections, sending e-mail, etc...) but I would also like to have it submit to SQL and start a new record once that is done without using two buttons. What happens now is someone clicks on submit, the record is created, but any subsequent "additions" are modifying the original record. This happens until they close the form.
Any assistance would be greatly appreciated.