I am very much a novice and got through by trial and error so far.
I am creating a form in which I want clients to select (in the first column) the type of product they own (lets say A,B,C,D,E....etc)
In the 2nd column is a list of solutions so prod 1, prod 2, prod 3 etc
Based on what they enter in column 1, I want my list in column 2 to be filtered to show only the solutions applicable to their product.
If they enter product 'G' : list in column 2 filters to a choice of prod 3, prod 5 or prod 7.
If they enter product 'D' : list in column 2 filters to a choice of prod 1, prod 3, prod 4.
Can this be done? If so, is it possible for anyone to explain how to do it...bearing in mind my novice status
Would be hugely grateful if anyone is prepared to give it a go.
Thanks in advance.