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