I have three lists, Projects, Milestone, and Tasks.
In tasks, I created cascade drop down for Projects and Milestone, so the user can choose from filtered option of Milestones after he chooses appropriate Project.
In both referring lists, Projects and Milestone, there are more than 20 items, so I get a complex dropdown lookup column in Tasks list (drop down acts like autocomplete single line of text after 20 items are in a drop down, this only happens in IE).
I did cascade drop down with help of SPServices, all works well if there are less than 20 items in referring list.
I found SPServices.SPCascadeDropdowns, example and information about cascade drop down with 20+ items, but I can’t make it work. Not sure if that is because of SharePoint 2013 we use or I am missing something else.
Also I found Marc D Anderson explanation how to make simple drop down from complex SPServices.SPCascadeDropdowns but that is not a solution for me as we will have 40 or even more choices and it wouldn’t look nice scrolling all the time around choices.
Basically what I want, is to make both complex drop down stay, so I can have auto completed option but with cascade option, when user chooses N.America, he should only get milestones from that project listed and not all milestones like nothing is connected. I found related article here, where it says if simpleChild attribute is set to True, drop downs should work.
My script is bellow:
Any suggestion how this can be implemented is greatly appreciated.
Source: Stack overflow jquery+or+mvc