Cascading Drop Downs is a way to dynamically filter data off the selection of a parent value. What this means is that in a case where you have two drop down lists, the second drop down may need to be filtered based off of the value of the first drop down list.
Setting Up Cascading Drop Downs
- Create Sharepoint List on your form site.
- Add Nested Drop Downs
- Now Add Filter on the Drop Downs to get the designated result.
For Example in the below screenshot ; if customer selects Function Location then Description should automatically appear in the Description Drop Down i.e. if Function is SP-000XXX-BD-BDXT- then all the three values for Description should appear in second drop down i.e. Clean Gutters/Need Gutter/Clear wells.
On The Second Drop Down (where values should be filtered ) click on Filter -and add Filter based on the Function Location.
Also see attached sample solution as an example