SharePoint 2010: Cascading Dropdown for Lookup with more than 20 items

When your list reaches 20 items or more, SharePoint decided to automatically replace this simple, clean, and elegant dropdown with some messy, sloppy, and difficult-to-use Complex Dropdown. This is meant to be an upgrade. The text box, with jQuery behind it, allows users to type the item that they’re looking for (which you can actually already do with a dropdown). However, in practice, it is prone to unexpected behavior:

Read some SharePoint 2013 tutorials below:

Cause:
I have a requirement to cascade country and state dropdown in SharePoint list. I have tried it using SPCascadeDropdowns and it’s not working more than 20 items in child dropdowns. This states my child dropdowns:


SharePoint 2010:Cascading Dropdown for Lookup with more than 20 items
SharePoint 2010:Cascading Dropdown for Lookup with more than 20 items

Solution:
If set to true, the child dropdown will be converted to a “simple” dropdown – only if it is a “complex” dropdown on page load. Edit the page in the browser and add a Content Editor Web part, modify the web part and show the Source Editor to add the following code.:

http://localhost:12813/pic/

SharePoint 2010:Cascading Dropdown for Lookup with more than 20 items
SharePoint 2010:Cascading Dropdown for Lookup with more than 20 items
SharePoint 2010:Cascading Dropdown for Lookup with more than 20 items
SharePoint 2010:Cascading Dropdown for Lookup with more than 20 items

We made the cascading lookup to display more than 20 items successfully. The lookup column now works fine for more than 20 entries also.

Donwload Hub site pdf

Download SharePoint Online Tutorial PDF FREE!

Get update on Webinars, video tutorials, training courses etc.

>