I've got two columns of dependedent validated lists. If you change the first column, it doesn't change anything to the second unless you click it. Is there any way to setup anything to maintain data consistency or at least put something there that tells the user to make another choice? Anything but the previous value would be great! Part of the problem is that changing the list selection of a cell with validation doesn't trigger any events (that I know of).
Any ideas?
Any ideas?