Newbie Questions

Re: Cascading lists

B.Shiva Prasad — Mon, 21 May 2007 08:43:16 GMT

Hi Soham,

Yes, Gregs blog is good ofcourse, any way i too learnt some thing with this discussion.

Re: Cascading lists

Soham Bhatt — Mon, 21 May 2007 05:34:01 GMT

Hi Shiva, My apologies - it works all good and ofcourse Greg Collin's blog is effective if i considered case sensitives........before i forgot to use to current so the repating section was carrying over the values. Then when i used current() i used current()/my:city instead of current()/my:City. 'C' of City should be in in caps and it all solved. wonder the caps error wasnt picked up by infopath. But thanks again for your help.

Re: Cascading lists

Soham Bhatt — Mon, 21 May 2007 04:55:00 GMT

Hi Shiva, thanks for the help - but the value of the drop down (from previous selection) and the texbox (from previous selection) still repeats/carries over when i insert another section.

Greg Collin's post (http://www.infopathdev.com/blogs/greg/archive/2005/07/14/Create-a-Repeating-Cascading-List-from-a-Hierarchical-Data-Source.aspx) does not address this issue.

Re: Cascading lists

B.Shiva Prasad — Fri, 18 May 2007 11:02:37 GMT

Hi Soham Bhatt,

Take the Expression box instead of text box and put the condition just like the condition put in the drop down. You will get the result what ever you want.

Hope this will help you.

Re: Cascading lists

Soham Bhatt — Thu, 17 May 2007 07:27:21 GMT

Actually i tried changing the default value of the texbox to look into the datasource and applied filters - all works great. Except when i change the value in the hotel field (the value doesnt change) or insert another section (in the repeating table) - the value in the address textbox gets carried over from previous section. any ideas?

Re: Cascading lists

Soham Bhatt — Thu, 17 May 2007 07:09:28 GMT

Hi Shiva, That article is very helpful......wonder why i didnt search/look properly. i have a Q - i'm applying the sample logic into my repeating section. i have 2 drop downs city & hotel looking up the values from xml - all works great according to the blog/thread. i wish to introdue a new field (textfield) called address/location which will list the address based the hotel selection. i dont seems to apply the same logic theer as its not a drop down and cant apply any filters. the reason i want textbox instead of drop down is because each hotel will have only 1 address. anyway to address this?

Re: Cascading lists

B.Shiva Prasad — Thu, 17 May 2007 06:22:22 GMT

Hi Grazzers,

The blog is already there, see the link http://www.infopathdev.com/blogs/greg/archive/2005/07/14/Create-a-Repeating-Cascading-List-from-a-Hierarchical-Data-Source.aspx wasted a lot of time for this. Actually I tried with current() but done a mistake while taking the field.

Hope this will help you.

Re: Cascading lists

B.Shiva Prasad — Thu, 17 May 2007 05:24:41 GMT

Hi Grazzers,

Its very good morning for me, I tried 2 days for your solution at last today I got the solution.

Do like this, take an extra field and put a rule on the Activity drop down that if the Activity drop down is not blank then set the fields value as extra field = Activity drop down value.

Now filter the second drop down Analysis value by comparing as Activity field value in the xml is equal to extra field value.

You will get the solution, still have doubt please let me know.

Have a nice day.

Re: Cascading lists

Grazzers — Mon, 14 May 2007 12:37:05 GMT

Does anyone have any thoughts on my previous post? I have a meeting this week to try and sell Infopath and if I can't fix it I may have to ditch it

Many Thanks

Re: Cascading lists

Grazzers — Wed, 09 May 2007 18:01:54 GMT

Matt

Thanks for the quick response, and Lord knows I've tried looking through all manner of blogs, forums and questions, but no matter what I try to do the cascading list in a repeating section always picks up the entries from the previous section. Just to recap, I have an Activity drop down box and an Analysis drop down box. I created a cascading list (using xml) so when I choose an Activity code in the first box the relevant Analysis codes appear in the second box. The difficulty is that when I choose a different Activity code in the next section, not only does it shows the relevant Analysis codes, but it also shows the Analysis codes from the previous section. How can I make it so the drop down list only shows relevant choices and stops my laptop turning into a frisbee?

Regards

Re: Cascading lists

Matt Faus — Wed, 09 May 2007 17:27:08 GMT

Hey G,

We have several posts about cascading lists in our blogs, try that out: http://www.infopathdev.com/blogs/

Re: Cascading lists

Grazzers — Wed, 09 May 2007 17:21:52 GMT

Hi again

Unfortunately my question (ref# 19591) seems to have been overlooked re issues with lists picking up list information from previous lists. Any thoughts?

Thanks

Re: Cascading lists

Matt Faus — Tue, 08 May 2007 10:37:14 GMT

HI soham,

I'm not sure what your situation is like, but an OnLoad rule should suffice.

Re: Cascading lists

Soham Bhatt — Tue, 08 May 2007 06:52:36 GMT

Hi Matt - thanks for your reply. But how do i set the rule that sets the node that the drop-down is bound on to the value of "Please Select"?

Re: Cascading lists

Matt Faus — Tue, 08 May 2007 05:29:38 GMT

If it shows up as one of the choices in the drop-down, then you will add either code or a rule that sets the node that the drop-down is bound on to the value of "Please Select".