There are 5 dropdowns in browser enabled InfoPath 2010 form and I've
created a data connection to retrieve values from SP list (which holds
10000+ items).
I used OOTB filtering in dropdown fields and it slow down the performance of the form.
I also used custom code for filtering values from the large list thru' owssvr.dll and it results in slow script error.
What could be the best method to achieve cascading dropdown
functionality in InfoPath 2010 form to fetch values from a large SP
list (10k+ items) without any performance issues? Thanks in advance..
Any help is appreciated!!