RonMcK
03-19-2008, 11:33 AM
How 'deep' can one cascade the dependencies?
For instance, my worksheet has columns for Unit, Chapter, and Lesson. Using the instructions from the webpage MrSteve noted, I have the dependency between Units and Chapters working.
I adapted the 'dependent' column logic to create a validation for Lessons, however, it only partly works. After I enter Unit and Chapter, the Lesson will show the correct filtered dropdown list of Lessons for the selected Chapter.
The problem arises when I leave Unit and Chapter blank, then enter a ridiculous value (say '45') for Lesson number. When I go back and select values for Unit and Chapter and tab to Lesson and then tab out of Lesson, the worksheet fails to complain that the Lesson value is outside the range of acceptable values.
How to I tie lesson validation to the unit/chapter validation?
Accompanying is a copy of my worksheet with the lists I created for the dependent validations.
Thanks in advance,
For instance, my worksheet has columns for Unit, Chapter, and Lesson. Using the instructions from the webpage MrSteve noted, I have the dependency between Units and Chapters working.
I adapted the 'dependent' column logic to create a validation for Lessons, however, it only partly works. After I enter Unit and Chapter, the Lesson will show the correct filtered dropdown list of Lessons for the selected Chapter.
The problem arises when I leave Unit and Chapter blank, then enter a ridiculous value (say '45') for Lesson number. When I go back and select values for Unit and Chapter and tab to Lesson and then tab out of Lesson, the worksheet fails to complain that the Lesson value is outside the range of acceptable values.
How to I tie lesson validation to the unit/chapter validation?
Accompanying is a copy of my worksheet with the lists I created for the dependent validations.
Thanks in advance,