I've got two InfoPath 2007 Forms published to Sharepoint and configured to use Form Services. Upon submission of the first form, I need to calculate some values pass those as a few fields in a new instance of the second InfoPath form. I've configured the custom columns to allow user editing in a datasheet, which then allowed me to develop a workflow in Sharepoint Designer that creates a new item in the list which is the document library of the second form, and set all of the necessary fields to the correct values.
When I submit the first form, everything appears to work and the workflow creates a new item of the second form and successfully sets all of the necessary values. The problem is, though, that the item that is created seems to be a .xsn and not a .xml like it would be if I simply selected "New" from the menu at the top of the list. As a result, it opens in InfoPath and not in the browser like it is supposed to.
I tried changing the default Content Type from "Form" to a custom Content Type that I created based on the InfoPath form, but I got the same results.
What am I doing wrong?
Thanks!