Create dependent drop-down / list-box in InfoPath using filters

re: Create dependent drop-down / list-box in InfoPath using filters

Tom — Wed, 24 Mar 2004 21:17:00 GMT

Is there a way to accomplish this without SP1?

Infopath Team Has a Blog

Amanda Murphy's Weblog XBOX :: Technology :: Busin — Thu, 25 Mar 2004 04:03:00 GMT

From 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....

re: Create dependent drop-down / list-box in InfoPath using filters

Luigi — Thu, 25 Mar 2004 02:10:00 GMT

I 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.

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.

Any ideas

Cheers

Luigi

re: Create dependent drop-down / list-box in InfoPath using filters

InfoPath Team — Tue, 13 Apr 2004 19:05:00 GMT

To 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.

re: Create dependent drop-down / list-box in InfoPath using filters

James — Tue, 25 May 2004 14:13:00 GMT

I 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.

I am sure there is a simple way to fix it. I am just over looking it.

re: Create dependent drop-down / list-box in InfoPath using filters

Shirley — Wed, 26 May 2004 08:45:00 GMT

I also have the above problem.

re: Create dependent drop-down / list-box in InfoPath using filters

infopath — Mon, 16 Oct 2006 03:04:31 GMT

For the two above comments: in InfoPath 2003, you need to employ an XPath current() function, described in this article:

http://blogs.msdn.com/infopath/archive/2004/09/13/228881.aspx

InfoPath 2007 will do this for you.

Thanks,

- Alex