https://www.infopathdev.com:443/forums/46.aspx For questions concerning issues in the integration of SharePoint and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/78344.aspxMon, 07 May 2012 14:52:33 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:78344nee2ok0https://www.infopathdev.com:443/forums/thread/78344.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=78344<p>&nbsp;Anson,</p><p>Thanks for your suggestion. However, I will prefer out of the box solution due to budget constraints.</p><p>Thanks,</p>Neeokhttps://www.infopathdev.com:443/forums/thread/78295.aspxThu, 03 May 2012 17:29:34 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:78295Anson Hidajat0https://www.infopathdev.com:443/forums/thread/78295.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=78295You should look into DBXL&#39;s QueryDB web service.&nbsp; Its easy to use, requires no custom code, and sounds like it would satisfy your scenario.&nbsp; Here is a link for more info and to download a trial version: <a href="http://www.qdabra.com/en/products/DBXL.aspx">http://www.qdabra.com/en/products/DBXL.aspx</a>https://www.infopathdev.com:443/forums/thread/78273.aspxThu, 03 May 2012 13:55:07 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:78273nee2ok0https://www.infopathdev.com:443/forums/thread/78273.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=78273<p>&nbsp; </p><p> I am new to InfoPath and not a developer. I need help (possibly step by step) on how to design a form that can query data based on 3 tables in an SQL Server 2008 database. The tables have unique primary keys and can be connected using secondary keys. Table1(list of servers) is the main table and the other 2 are linked to it in a one-to-main relationship. I would like to query table 1 and if data exists, it will populate&nbsp;the form&nbsp;with information from both Table 1. If data does not exist, then it should open a blank form to input new data and submit to the database. The other requirement is that if data exists when I query Table 1, then I will have a detail button that when clicked will populate a repeating form with information from both Tables 2 (servers and applications running on them) and Table 3 (applications and their owners). I will also like like to query Table 3 for a application name and its owner. This form will be published to a SharePoint 2007 and SharePoint 2010 sites. My research on the internet and several forums require that I create REST web service. I am not a developer and so cannot do this. I hope there is way to resolve this with no code!!<br /></p> <p>Thanks for any help</p><p>Nee2ok <br /></p>