I have two column. one is called Goal and the other is called Projects Under Goal, i have different choices. If I select choice then projects should display choices which are related to one of the choices and vice versa.
Eg:
Goal: Has choice quality, Regulatory
and Projects has more choices
when we select quality under goal then it should show projects in related quality and if we select regulatory then it showed show projects in related to that and vice versa.
Can someone help me how I can do that in SharePoint 2010