This project has moved. For the latest updates, please go here.

Any functions that can filter a cascading dropdown based on a value selected in two previous field

Apr 17, 2015 at 11:53 PM
I have 3 fields (in order on the form): Network --> Category --> Issues

There are some issues in the category list that are duplicates. In other words:


Network A Create Account
                Update Account
Network B Create Account

A user will select a Network and the category will populate with the appropriate values. This works! What I need is for the Issues field to populate with distinct values based on the network and category. I saw some solutions which required me to modify the CAML query in the Cascading Dropdown and in the SPServices code but you didn't recommend. I'm not sure if I'm searching for the right terms as I'm not finding many hits in the Discussions. Thanks for your help.
Apr 29, 2015 at 1:30 PM
Did you look at using the matchOnId option? Note that values with identical text will confuse users, but that's a separate issue.