AnsweredAssumed Answered

How Do I Create a Multi Level Cascading Drop Down?

Question asked by nbalcom on Oct 1, 2015
Latest reply on Oct 5, 2015 by nbalcom

I'm trying to create a cascading drop down that depending on the first drop down calls different information from 1 list with a unique column that displays departments. In my case, I have a list called departments and a list called managers. In Departments I have just the various different departments. In managers I have a list with all the managers with a unique column id called "deptID". This states what departments the managers belong to.

 

cascading-drop.png

 

Another thing I've also tried...

I've also tried creating a cascading drop down that depending on the first drop down calls 1 of 9 separate lists. The first list is for departments. Depending on the department you choose I want it to call 1 of the lists that is a combination of managers. See the graphic below. Can I do this with 2 list lookup buttons? There has to be a way to format it. Should I be doing this some other way?

 

This post is pretty close.

Outcomes