InfoPath Dev

I've got a repeating table with several repeating fields, 2 of them are dropdown lists and another one is a textbox.

dropdown list 1 is filled by a web service.

Whate I want to achieve is:
When dropdown list 1 selection has been changed, call another web service (take the value of dropdown list 1 as parameter) to fill dropdown list 2 with a returned list of options, and the third web service (also take the value of dropdown list 1 as parameter) to fill the textbox with a single returned value.

It should work for each row in the repeating table seperately.

Is this possible?
If possible, how to do it?

I'm working on infopath 2007.

Thanks a lot...

Hi Xiaomu and welcome to the forum!

I think you should be able to do this with Rules, but code might make it easier.  The only problem I see with this is that since you will be dynamically changing the data source that the second and third drop-downs populate from, then the drop-downs on previous rows will show bogus data since their values are no longer in the secondary DOM. 

I can understand wanting to only pull down the necessary information to gain performance, but the overhead of the extra web service calls with every drop-down selection might not be what you're looking for.  The method I describe below will mean that every time the user selects a value from the first drop-down the form will freeze for about a second before returning control to the user.  This one second freeze will be perceived by the user as very bad performance, even if the overall perf is better than downloading everything you need at once. 

 I don't know your exact scenario, but I would highly recommend trying to download all the data that you need when the form opens and then just using dynamic filters like any old cascading drop-down.  With this method, you could also use InfoPath 2007's cached secondary data source feature.

Here's a link on the traditional cascading drop-downs: http://www.infopathdev.com/search/SearchResults.aspx?q=cascading+drop-down&a=1 

So, if you really want to do this, here's how:

1. Set the rule on the first drop-down to fill the value of the queryField in the web service data connection to its value.
2. Query the web service
3. Make sure the second drop-down is pointed and filtered at the web service data connection.

 

Thanks very much Matt... Greg's cascading works perfect...

However, I cannot get the same thing working for a text box... In the filter of textbox filter refused to accept current()/my:XXX as a valid formula...

 Any solutions for this?