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.
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.