I have a form that has two drop down menu’s. Each menu is pulling A LOT of values from a SharePoint list or in some cases even a web service. I want to make it so that the values of drop down 2 don’t populate until a selection is made in drop down 1, in which case it filters the values in drop down 2 and populates drop down 2. This way, the form doesn’t take so long to load.
Does disabling the 2nd drop down through conditional formatting so that it's only enabled when a selection in the first drop down is made accomplish this?