I have recently completed form, that I have just found out needs to also be submited to a database. I read that to do this natively in InfoPath, I have to select it prior to building the form. That being said, would it be easier/better to recreate this from, or use a sharepoint workflow to trigger when the form also gets submited to a sharepoint form library (wss 3.0) which it currently does? I'm assuming it will be easier to rebuild the form, though no easy task, so I have a few questions about the sql route.
1. Should I have one database per form, OR, one InfoPath database, with a table for each form? Any best practice for that?
2. Question 2, I have an optional repeating section for name on my form. How will sql handle that? Can it? Will it create a 2nd record with all the same info and just a different name? (that would be ideal).
Warning, I'll probably have 100 more questiosn to whoever responds to this. :-)