Create dependent drop-down / list-box in InfoPath using filtershttp://blogs.msdn.com/b/infopath/archive/2004/03/24/create-dependent-drop-down-list-box-in-infopath-using-filters.aspxSummary
Suppose you want to have the items listed in a drop-down be dependent on the selection of another drop-down (this is also known as "cascading dropdowns). If you have InfoPath Service Pack 1 installed, you could use the "Filter Data..." featureen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)re: Create dependent drop-down / list-box in InfoPath using filtershttp://blogs.msdn.com/b/infopath/archive/2004/03/24/create-dependent-drop-down-list-box-in-infopath-using-filters.aspx#10614659Thu, 14 May 2015 00:27:48 GMT91d46819-8472-40ad-a661-2c78acb4018c:10614659Anita <p>Any way to get this to work from Excel? </p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10614659" width="1" height="1">re: Create dependent drop-down / list-box in InfoPath using filtershttp://blogs.msdn.com/b/infopath/archive/2004/03/24/create-dependent-drop-down-list-box-in-infopath-using-filters.aspx#10613022Thu, 07 May 2015 13:36:19 GMT91d46819-8472-40ad-a661-2c78acb4018c:10613022kitty<p>on the state property, if I add a rule to set City to empty, it does not change at all, the first few selected cities stays there forever. </p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10613022" width="1" height="1">re: Create dependent drop-down / list-box in InfoPath using filtershttp://blogs.msdn.com/b/infopath/archive/2004/03/24/create-dependent-drop-down-list-box-in-infopath-using-filters.aspx#10606669Fri, 10 Apr 2015 11:33:15 GMT91d46819-8472-40ad-a661-2c78acb4018c:10606669ashish<p>If you are interested in learning advance use of drop down list with Conditional Formatting</p>
<p><a rel="nofollow" target="_new" href="http://www.exceltip.com/tips/cascading-drop-down-list-using-conditional-formatting-in-microsoft-excel-2010.html">www.exceltip.com/.../cascading-drop-down-list-using-conditional-formatting-in-microsoft-excel-2010.html</a></p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10606669" width="1" height="1">re: Create dependent drop-down / list-box in InfoPath using filtershttp://blogs.msdn.com/b/infopath/archive/2004/03/24/create-dependent-drop-down-list-box-in-infopath-using-filters.aspx#10604570Wed, 01 Apr 2015 15:13:04 GMT91d46819-8472-40ad-a661-2c78acb4018c:10604570Leslie<p>I want to do something similar to this but using a check box to filter the 2nd drop list. Any help on how to make that happen?</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10604570" width="1" height="1">re: Create dependent drop-down / list-box in InfoPath using filtershttp://blogs.msdn.com/b/infopath/archive/2004/03/24/create-dependent-drop-down-list-box-in-infopath-using-filters.aspx#10381094Fri, 28 Dec 2012 07:01:33 GMT91d46819-8472-40ad-a661-2c78acb4018c:10381094Devanshi<p>I do this &#39;filter&#39; and it returns only 1 row in the drop down, while it should return 4 or 5 different values in the dropdown. </p>
<p>PS: using Infopath 2010.</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10381094" width="1" height="1">re: Create dependent drop-down / list-box in InfoPath using filtershttp://blogs.msdn.com/b/infopath/archive/2004/03/24/create-dependent-drop-down-list-box-in-infopath-using-filters.aspx#10245093Wed, 07 Dec 2011 15:17:12 GMT91d46819-8472-40ad-a661-2c78acb4018c:10245093jojo<p>how do I create the xml the city drop down obtain its values from?</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10245093" width="1" height="1">re: Create dependent drop-down / list-box in InfoPath using filtershttp://blogs.msdn.com/b/infopath/archive/2004/03/24/create-dependent-drop-down-list-box-in-infopath-using-filters.aspx#10135271Tue, 01 Mar 2011 06:59:16 GMT91d46819-8472-40ad-a661-2c78acb4018c:10135271Rasheed<p>Thank you man that was a good article</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10135271" width="1" height="1">re: Create dependent drop-down / list-box in InfoPath using filtershttp://blogs.msdn.com/b/infopath/archive/2004/03/24/create-dependent-drop-down-list-box-in-infopath-using-filters.aspx#10006441Mon, 03 May 2010 17:09:51 GMT91d46819-8472-40ad-a661-2c78acb4018c:10006441namariegaudi<p>I have created an InfoPath form and have a specific field linked to another site via a data connection from where I collect a set of alphanumerical codes (ex: WTR001A, GDL542B). I want to semi filter the codes. I don’t want to sort them alphabetically for now, just worry about filtering the options upon selection of a specific building location.</p>
<p>My 1st filter field asks the user to select a building location which are:</p>
<p>• AMS = Americas</p>
<p>• BA = Buenos Aires</p>
<p>• BCN = Barcelona</p>
<p>• Etc.</p>
<p>Upon the user’s selection I want the “codes” mentioned above to display only the ones pertaining to that building location. Perhaps having a XML file that specifies if a user selects Barcelona, then only show BCNXXX “codes” if a user select Singapore, then only SGPXXX codes show</p>
<p>Would an XML file work? If so how would it look like?</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10006441" width="1" height="1">re: Create dependent drop-down / list-box in InfoPath using filtershttp://blogs.msdn.com/b/infopath/archive/2004/03/24/create-dependent-drop-down-list-box-in-infopath-using-filters.aspx#830208Mon, 16 Oct 2006 03:04:31 GMT91d46819-8472-40ad-a661-2c78acb4018c:830208infopath1<p>For the two above comments: in InfoPath 2003, you need to employ an XPath current() function, described in this article: </p>
<p><a rel="nofollow" target="_new" href="http://blogs.msdn.com/infopath/archive/2004/09/13/228881.aspx">http://blogs.msdn.com/infopath/archive/2004/09/13/228881.aspx</a></p>
<p>InfoPath 2007 will do this for you. </p>
<p>Thanks,</p>
<p>- Alex</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=830208" width="1" height="1">re: Create dependent drop-down / list-box in InfoPath using filtershttp://blogs.msdn.com/b/infopath/archive/2004/03/24/create-dependent-drop-down-list-box-in-infopath-using-filters.aspx#142104Wed, 26 May 2004 08:45:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:142104ShirleyI also have the above problem.<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=142104" width="1" height="1">re: Create dependent drop-down / list-box in InfoPath using filtershttp://blogs.msdn.com/b/infopath/archive/2004/03/24/create-dependent-drop-down-list-box-in-infopath-using-filters.aspx#141266Tue, 25 May 2004 14:13:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:141266JamesI have a dependent drop-downs/list-box in InfoPath using Filters working in a repeating table for the first row; however, the subsequent rows contain any previously filtered data.
<br>
<br>I am sure there is a simple way to fix it. I am just over looking it.
<br><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=141266" width="1" height="1">re: Create dependent drop-down / list-box in InfoPath using filtershttp://blogs.msdn.com/b/infopath/archive/2004/03/24/create-dependent-drop-down-list-box-in-infopath-using-filters.aspx#112498Tue, 13 Apr 2004 19:05:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:112498InfoPath TeamTo do this without SP1: lets say you have a query for the data adapter that you want to update based on the selection of another drop-down. What you want to do is write script such that on the change of the primary drop down, you update the query for the adapter you want to refill itself and then requery that adapter.
<br><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=112498" width="1" height="1">Infopath Team Has a Bloghttp://blogs.msdn.com/b/infopath/archive/2004/03/24/create-dependent-drop-down-list-box-in-infopath-using-filters.aspx#95664Thu, 25 Mar 2004 04:03:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:95664Amanda Murphy's Weblog XBOX :: Technology :: BusinFrom Lauraj's blog, I just read that the Infopath team has a blog. Great news. I didn't realize but then again I haven't been doing much blog related reading (or writing for that matter) for the past couple of weeks so I think it's time to catch up. Today's post is on one of my fave new things from the SP1 preview. Using filters on your dropdown boxes and secondary data sources....<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=95664" width="1" height="1">re: Create dependent drop-down / list-box in InfoPath using filtershttp://blogs.msdn.com/b/infopath/archive/2004/03/24/create-dependent-drop-down-list-box-in-infopath-using-filters.aspx#95688Thu, 25 Mar 2004 02:10:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:95688LuigiI battled bravely with this for a while before cracking it with a secondary data source I created from an access database but when I tried to hook it up to the SQL server I lost the dependent dropdown values.
<br>
<br>The connection works fine with both dropdowns populated with the full lists until I try to build the filter, then the dependent dropdown drops out.
<br>
<br>Any ideas
<br>
<br>Cheers
<br>
<br>Luigi<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=95688" width="1" height="1">re: Create dependent drop-down / list-box in InfoPath using filtershttp://blogs.msdn.com/b/infopath/archive/2004/03/24/create-dependent-drop-down-list-box-in-infopath-using-filters.aspx#95541Wed, 24 Mar 2004 21:17:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:95541TomIs there a way to accomplish this without SP1? <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=95541" width="1" height="1">