Hi all,
I'm somewhat new to this linked drop down lists thing and I'm having a little problem with it.
I was able to make two dependent lists that work really nice when I'm first selecting the options as you can see in this first picture:
But then, when I change the value in the first list (parent) the old value previously selected in the second list (sibling) is kept even though it has not been registered as a valid option. I often end up with weird outcomes as the picture below shows:
What I want is that the dependent sibling list (cell G3) goes blank automatically or displays an error message whenever the parent main list (cell F3) is changed. How can I possibly do that?
Big thanks to all!
ps: I'm working with a rather complex data related to my area of study so I made this simple yet helpful example just to make things easier to understand.
I'm somewhat new to this linked drop down lists thing and I'm having a little problem with it.
I was able to make two dependent lists that work really nice when I'm first selecting the options as you can see in this first picture:
![e561864b71.png](/board/proxy.php?image=https%3A%2F%2Fi.imgsafe.org%2Fe5%2Fe561864b71.png&hash=61020f51f208c5b9f6f52732ae848172)
But then, when I change the value in the first list (parent) the old value previously selected in the second list (sibling) is kept even though it has not been registered as a valid option. I often end up with weird outcomes as the picture below shows:
![e56d48f64e.png](/board/proxy.php?image=https%3A%2F%2Fi.imgsafe.org%2Fe5%2Fe56d48f64e.png&hash=a6f220f5a12e53245962b236c853d035)
What I want is that the dependent sibling list (cell G3) goes blank automatically or displays an error message whenever the parent main list (cell F3) is changed. How can I possibly do that?
Big thanks to all!
ps: I'm working with a rather complex data related to my area of study so I made this simple yet helpful example just to make things easier to understand.