InfoPath Dev

 I am wondering if the following is possible:

• Create an InfoPath form in InfoPath 2010 that has a 'Submit' button that when the button is clicked the form will:
  
• Send some specific data to a SharePoint 2010 list
• Send different specific data to a SharePoint 2007 list
• and send data to an SQL database table

I have a SharePoint 2010 site where the form will be accessed, but there are some sites/lists that are still on SharePoint 2007 that will need some of the data from this form.  Also, I need to send some data from this form to a Quality Center database.

 Can this be done?

Hi Bush3102,

Yes, you can do all three, but you will need to either write some code or use one of the InfoPath accelerators out there - for example: qRules and/or DBXL. InfoPath 2010 list forms do not support sending to 2007 lists without code and vice versa with 2007 form library forms. Form library forms can connect directly to a database, but Web services are a best practice sine they create a middle-tier which provides greater flexibility when things change. qRules supports mapping your InfoPath form to both a 2007 and a 2010 list and there are videos that show how to do that (for example: http://www.youtube.com/watch?v=mpueygXbV-A&feature=player_embedded). DBXL is a Web service that will connect your form to a database (for example: http://www.youtube.com/watch?v=nPhyS2CtScc).

Free trials of both "accelerators" exist on the Qdabra dot com web site. And, the tools are very inexpensive to buy. 

Disclaimer: this web site is a free resource to the InfoPath community. Qdabra pays for it's annual maintenance and guarantees responses to most of the threads.