https://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/16952.aspxThu, 16 Jun 2005 22:32:18 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16952Shanthi Reddy0https://www.infopathdev.com:443/forums/thread/16952.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16952What are the errors that you get when you try to Query or submit? Can you give more details?<br /><br />Shanthi<br />InfoPathDev Indiahttps://www.infopathdev.com:443/forums/thread/16951.aspxTue, 14 Jun 2005 16:20:13 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16951Matrix3330https://www.infopathdev.com:443/forums/thread/16951.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16951I find that if i want the query to work, then db1/tblA needs to be the main connection...but then submit does not work correctly.<br />If i want the submit to work, then db2/tblB needs to be the main connection...but then query does not work correctly.https://www.infopathdev.com:443/forums/thread/16715.aspxTue, 14 Jun 2005 15:43:47 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16715Matrix3330https://www.infopathdev.com:443/forums/thread/16715.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16715I have been stuck on this for days and would appreciate any help! Here is basically what we want to do:<br /><br />----------<br />Database1/TableA = retrieve data from here<br />Database2/TableB = write data to here<br /><br />We need a dropdownbox with ItemNumber(db1/tblA) on form load. The user selects ItemNumber(db1/tblA) and some fields below this are populated with that ItemNumber's data from db1/tblA. This can be done right when the user selects a different item from the drop down, or after the user presses a select button next to the dropdown.<br /><br />Now an item is selected and some fields below that are populated. The user can now enter a comment and select some other checkbox and radio button items.<br /><br />Finally, the submit button is pressed and the data from all the fields is inserted into db2/tblB.<br />----------<br /><br />I have tried everything that we can think of and everything we have found from researching and can not get it to work.<br /><br />Can someone PLEASE explain how to do this, or create a sample form for me that does all of this.<br /><br />Thank you.