This article outlines the steps on how to fix the threshold issue with a list containg cascading lookup field type
There is an issue with a list containing cascading look-up field type with 5000+ items. When you try to use the cascading look-up a threshold error is displayed.
KWizCom Cascading Lookup Plus Field Type Standard Evaluation 3.x.xx for SharePoint 2007
KWizCom Cascading Lookup Plus Field Type Standard Evaluation 13.x.xx for SharePoint 2010
Please perform the following workarounds to resolve the threshold issue.
1. Increase threshold limit on the list
2. Change enablethrotling property - run command in PowerShell to set to false
$web = Get-SPWeb http://whateverWeb
$list = $web.Lists[“List Title”]
$list.enablethrottling = $false
Optionally provide private feedback to help us improve this article...
Thank you for your feedback!