Cascading failure

Have you gone through this support article Adding Cascading Select Questions?

Maybe this post discussed previously should also be helpful: