Archive for May, 2010

Cascading Lookups - Another approach

Tuesday, May 11th, 2010

I have 3 dropdowns. In the last few days, the middle one was populated with more than 19 items. As you know from previous posts, the 20th item triggers IE (only) to change the control type. Before, my 3rd dropdown contained more than 19 items, but I didn’t care because it did not cascade. But, now that the middle dropdown has changed type, I ran into problems. The problem is that I could not get the on-change event to behave properly. The event fires when you tab off the control, so I had a hard time figuring out what the current value was for the cascading control.

So, to make a very long story short, I changed the three dropdowns fields to edit fields. And, in Designer, I added 3 unlinked dropdowns controls. I changed my javascript to cascade the unlinked dropdowns and everything worked.

I had to make sure I moved values from the unlinked controls to the edit fields, but other than that, it was easy.

This is the best solution so far. Stay tuned though.