https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/27567.aspxMon, 31 Mar 2008 15:48:24 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:27567Clay Fox0https://www.infopathdev.com:443/forums/thread/27567.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=27567<p>The key is web services.</p> <p>The basic database connectivity in InfoPath has limitations as you have encountered.</p> <p>InfoPath was designed to use web services and they give you all of the functionality.</p> <p>You can both query and submit to multiple tables.</p> <p>Send me an email and I could show you some examples.</p>https://www.infopathdev.com:443/forums/thread/27565.aspxMon, 31 Mar 2008 12:25:29 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:27565stuck0https://www.infopathdev.com:443/forums/thread/27565.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=27565<p><font size="3"><font face="Times New Roman">Does anyone know if it&#39;s possible to run&nbsp;2 separate queries in InfoPath 2003 to&nbsp;a SQL Server 2000 database?</font></font></p><font size="3"><font face="Times New Roman">I can get the first one up and running but then I want a second query which queries a different table. So I change my main connection to add&nbsp;a new table, but it will ask for a relationship. These two tables are not necessary related. So how would you add new table to query it?</font></font> <p>&nbsp;</p>