Creating cascading drop down list in SharePoint using InfoPath Designer

This tutorial shows you how to use InfoPath Designer to customize the default SharePoint list form and create cascading drop down list. For example, you select a customer in a drop down list, and in the second drop down list, it shows you all the staff members for this customer.

[MRL]

Brilliant! Thanks heaps, I was stuck on the filter comparing company to company - I wasn't selecting "Main". Very clear and concise, thanks again!

[favoritefm]

Hi Lin! Thank you for this great demonstration. I am trying to implement the cascading style into my SP. The difficulty I am facing right now is creating the relationship between my lists. I have created 3 different lists in my SharePoint 2013. There is a relationship in short one should be the parent and the other two will be the children. Would you mind sharing the steps I need to do to achieve that tie? Thanks!!

[mhf]

Hi Lin, I am having an issue, i perform all the required steps but my second drop down box is not populating with values, if i put static value in filter its works fine. Any idea why is that

Muhammad

[sarikakumari]

Hi Lin, I have quick question for you. I am planning to create a Q&A page with some products will be listed in drop down button. So basically you can select a product and type question and click on search butter to look for the answers. it is possible in SharePoint using InfoPath Designer?

[AnnieHueAnh]

Hi Lin, if I don't change default value to ID, I get the validation error only positive integers value but if I changed the default value to Title, the customer staff has empty in the drop down