Hello -
I am very new to xml files and xpath.
I have 4 multiselect dropdowns all using the same xml datasource.
Each dropdown is based on attributes of the same tag.
I would like to make them cascade, but I can only figure out how to do it by passing in one value per parameter at a time.
I would like to pass in more than one.
e.g. country - state - city
1. select USA as country
2. pass USA to state - got this, ok
3. now, select Washington, Oregon, California
4. how do I pass these states to city's xml/xpath datasource for filtering (so that all WA, OR, CA cities are listed [alphabetically])?
I used this article as a starting point and built the dropdowns using a version of this and some custom code to remove duplicates.
http://support.microsoft.com/kb/308333
I feel like I'm recreating the wheel with the custom code, but it was easier than me fussing with the xpath syntax - for now. (it is made more difficult because i need both id and name attributes returned and then dedupe - what i have works)
Any help on if it's possible and/or how to pass in multi-valued (a comma separated list of values) to a parameter is greatly appreciated.
Thank you, Megan