Controls

Re: Cascading Dorp Down List in Repeating Table (Using Filters)

Jimmy — Tue, 05 Jul 2011 18:43:49 GMT

If you click a field in the data source taskpane, there should be an option to edit its rules. Do this for the field bound to the first dropdown, and add a rule whose action is to set the field bound to the second dropdown to blank. This rule will execute whenever the first field's value changes.

Re: Cascading Dorp Down List in Repeating Table (Using Filters)

mlindenbach — Mon, 04 Jul 2011 18:33:46 GMT

It is 2007

Re: Cascading Dorp Down List in Repeating Table (Using Filters)

Jimmy — Mon, 04 Jul 2011 17:58:06 GMT

What version of InfoPath are you using?

Re: Cascading Dorp Down List in Repeating Table (Using Filters)

mlindenbach — Mon, 04 Jul 2011 17:23:18 GMT

Thank you for your quick resonse! Sorry if this is a stupid question but how do I create that rule?

Thanks,

Melissa

Re: Cascading Dorp Down List in Repeating Table (Using Filters)

Jimmy — Mon, 04 Jul 2011 17:02:49 GMT

You should put a rule on the ContainerType field to always reset Size to blank. A dropdown will show the bound field's current value in addition to the valid options if the current value is not in the available options.

Cascading Dorp Down List in Repeating Table (Using Filters)

mlindenbach — Mon, 04 Jul 2011 16:35:27 GMT

Hello! Thank you in advance for your time! I have created a cascading drop down list that links a type of bin to the size options available for it. I have assembled this using a filter (based on an Access table) as described on the Microsoft Office website (http://office.microsoft.com/en-us/infopath-help/create-a-cascading-list-box-HA001117713.aspx). The only issue is that because I have a repeating section every time I open a new section the old options are available. For example:

Container Type	Sizes Available
Bag	1 M3
BB	0.25 M3
	0.50 M3
	0.75 M3

If I were to select Bag in my first option – only the 1 M3 would appear as an option (this is correct). If I were to open another section (or even go back and change my option) to BB All the BB options would appear along with the Bag sizing option (1M3) which is not correct. I need help on how to fix this.

Thanks again for your help! I really appreciate it!

Melissa