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/57783.aspxMon, 09 Aug 2010 06:23:56 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:57783Mel Clemente0https://www.infopathdev.com:443/forums/thread/57783.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=57783<p>Hi,</p><p>Cascading dropdowns can really be tricky. Have you considered using a web service that handles this? Qdabra&#39;s Database Accelerator (DBXL) has a web service that allows querying databases. It comes with a Query Builder tool that helps you create strings for filtering, and even sorting. Here&#39;s a documentation on how to <a href="http://www.infopathdev.com/files/folders/database_integration/entry56214.aspx">implement static and dynamic queries using QueryDB</a>, just to have an idea how to set it up and how it works. The document does not have examples of cascading dropdowns but once you&#39;ve built your data connections and have populated your form with data, setting up cascading dropdowns will really be easy - no need for code!<br /></p><p>You can try Qdabra&#39;s DBXL for free. Download it <a href="http://www.qdabra.com/en/products/DBXL.aspx">here</a> and see if it&#39;s what you&#39;re looking for. Let us know if you need further help setting it up.</p><p>Cheers! <br /></p>https://www.infopathdev.com:443/forums/thread/57665.aspxThu, 05 Aug 2010 12:43:39 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:57665bahrom78930https://www.infopathdev.com:443/forums/thread/57665.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=57665<p>I&#39;ve been looking around for the stuff on how to create cascading dropdowns in a sql database form on infopath 2007 for the past week and I can&#39;t find anything, can somebody please help me. So I have a database form in infopath 2007 connected to a table in sql server 2008. The table has three columns: Utility, Adjustments and Applies to. So my adjustments depend on utility and my &quot;applies to&quot; depends on adjustments. I&#39;ve looked through many examples, I managed to create cascading&nbsp; dropdown using a regualar blank form, using a .xml file, which I created by copying the utilities, adjustments, etc. into a notepad using an example from one of the posts on msdn. However that form is not connected to anything. So I have a blank form with cascading lists that doesn&#39;t connect to any database and a form without cascading dropdowns that connects to a database. I need my form to have cascading dropdowns and the values for those dropdowns have to be coming from a database table. I don&#39;t know any coding languages, so I need to be walked through this taking baby steps, telling me exactly what to do (maybe write in Visual Studio)&nbsp;and where to do/write it. Any help would be appreciated. Please help ASAP. Thank you.</p> <p>&nbsp;P.S. For the blank form with cascading dropdowns, I managed to connect to a database using Tools-&gt; Data Connections-&gt; Add, etc.., however I just can&#39;t pull out any data from my table and the filters are not working the form that does get data from the sql server.</p>