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/87369.aspxSun, 24 Feb 2013 20:42:25 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:87369Patrick Halstead0https://www.infopathdev.com:443/forums/thread/87369.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=87369<p>Hi Endless112. Thanks for posting!</p><p>What is &quot;the traditional filter suggestion&quot;?</p><p>You need to execute a query using data from your form. Out-of-box SQL data connections do not accept field parameters as part of the SQL query text. You could use a Web service that does it and pass the value to it. Qdabra&#39;s DBXL Web service has a Query DB method which is easy to configure to do this. Another approach is to write some code in your form. qRules also has a command that lets non coders do the same thing using just a rule. Both DBXL and qRules are free trials. </p><p>If you don&#39;t have much data (&lt;1000 rows), why re-query at all? Just query it all into your form and do the filtering using out-of-box filters.</p><p>Good luck!</p>https://www.infopathdev.com:443/forums/thread/87318.aspxFri, 22 Feb 2013 08:06:27 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:87318endless1120https://www.infopathdev.com:443/forums/thread/87318.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=87318Help would be appreciated with below form structure: Fields: Production Line - 1,2 &amp; 3 Item Description I would like the second dropdown list (item description) to narrow selection based on selecting line 1,2,3. Database structure is: itemdescription = Item Description itemgroupcode = Defines line 1,2,3 How would I be able to create a cascading list with above criteria. The traditional filter suggestion through the forum doesn&#39;t help in this case? Or does it?