Newbie Questions

Re: Cascading Drop Downs - Need Clear Child Drop Down Value When Click to Select New Parent

infopathy — Tue, 30 Dec 2014 00:23:05 GMT

Hi Brea,

I got my solution. Turns out the instruction "...Second, uncheck the “Automatically retrieve data when the form is opened” does not work -- at least for me in SP 2013/InfoPath 2013. It took me having to reproduce my second field, Subcategory, and leaving that option checked.

I then followed the balance of instructions down to "...If you preview your form now you should be able to select a region and see the correct list of offices populated." and it worked.

Thanks for your response.

Re: Cascading Drop Downs - Need Clear Child Drop Down Value When Click to Select New Parent

infopathy — Mon, 29 Dec 2014 20:37:57 GMT

In the meanwhile I found this: http://www.pointbeyond.com/2011/11/20/cascading-dropdowns-in-infopath-2010

But so far cannot make work and unsure why. I have no third field so maybe getting confused. I would appreciate you give it a scan. Thanks a lot.

Here are some snaps of my attempt...

Upload not seem to work so here is url: https://www.flickr.com/photos/130317962@N07/sets/72157647673165894/

Re: Cascading Drop Downs - Need Clear Child Drop Down Value When Click to Select New Parent

Bre Huston — Mon, 29 Dec 2014 20:06:54 GMT

Hello infopathy,

The best way to accomplish this logic would be to add an action rule on the parent dropdown to set the child dropdowns to blank. If that is not what you had envisioned, reply with a few more details or an example of your form and I can provide some more suggestions.

Best Regards,
Bre

Bre Huston | Project Manager

Qdabra® Software / InfoPathDev.com / FormsQuo / 877.544.2389 main / 425.318.7843 direct

Business Process Automation for Everyone – Streamline data gathering to turn process into knowledge.™

Cascading Drop Downs - Need Clear Child Drop Down Value When Click to Select New Parent

infopathy — Mon, 29 Dec 2014 19:44:53 GMT

In my form am using two connected fields, ie, parent, child. The work fine. However, sometimes after I have selected a parent child pair of values I need change the parent but on doing so the former child remains and appears a member of the new child list for the new parent. I want to be able to clear the child value when I click on the parent drop-down to select a new parent.

Any help much appreciated. Thanks.