How to set up list(s) for 3-level dependent data validation lists?
Posted on 2014-02-20
Hello - I'm an Access developer that has been tasked with spiffing up a spreadsheet that holds employee rewards. It has the expected data: division, department, reward area, reward type, etc...
It wasn't a problem to set up the Division-Department table for dependent data validation lists, but now they are telling me they want to add a 3rd level of "Section".
so, is there a smart way to set up for a 3-level grid?
If it's just a single 3-column grid, how do you keep from getting Dept values in the Dept DVL that are repeated for every Section element?
If it's 2 2-column grids of Division-Departments, and then Departments-Sections, then the user has to keep it straight as time goes by and they have to maintain those grids.