Re: Cascading dropdown list in repeating table

Patrick Halstead — Tue, 21 Jun 2011 00:05:31 GMT

Hi Sandy,

Have you searched this forum for "Cascading Dropdowns" or "Current" ? Greg has some good blogs and there are tons of posts.

Cascading dropdown list in repeating table

sandyleo — Mon, 20 Jun 2011 21:59:55 GMT

Hi,

I am trying to search item in repeating table but i am not getting correct value. Can anyone provide input? I am using Infopath 2010. I need to solve this without writting code.

Scenario: This problem is related with Cascading dropdown list in repeating table.

<Country> --

<State> ---- List of States

<Cities> ---- Names of Cities under the selected State

<StateList>---- Name of the states which are having city name selected in above drop down. [ City Name can be same for multiple states like Madison can be in Wisconsin and in Illinois as well. If I select Madison, it should show all the states which are having city named as 'Madison'. in this case, it should return IL and WI.]

I am trying to write expression for 3rd dropdown 'StateList' but it is not returning the correct result. If city is not listed at first position in collection, it is not returning the state name. Suppose if Madison is present at first position in the list for IL, it will return the value otherwise not.

I am using expression like:

Country/State/@Name[contains(../City/@Name, ../../../CityName)] - Where CityName is the city selected in dropdown.

Any pointers please........

Sandy

Newbie Questions

Re: Cascading dropdown list in repeating table

Cascading dropdown list in repeating table