I have created a list on my SharePoint page with multiple dropdown menus when a new list is created. However, I was wondering that when an option is selected in the first drop down menu, if there was a way so that in the second drop down menu only certain options can be selected.
Currently my first dropdown menu is title projects and has all the main projects listed to choose (like 4 or 5 options). The second is for sub project. What I want to be able to do so say option 1 is chosen in the first drop down, only the certain sub projects that are related to option 1 in the first drop down appear in the second dropdown.
Hope that makes sense.