Dec 14th, 2014, 7:43 AM
Is it possible to selectively use a drop down list based on the entry made in a different field?
To illustrate what I have in mind and would wish to do:
Field 1 is populated by an entry selected from a drop down list giving a choice between 'door', 'window' and 'garden'.
Field 2 is a detail relating to the content in Field 1 and is best filled by using a drop down list of choices. BUT, the content of the drop down list needs to be tailored relevant to the intial choice selected in Field 1 as the choices for door, window and garden are different.
For 'door' in Field 1 the multiple choices might be 'front', 'back', 'patio';
For 'window' in Field 1 the multiple choices might be 'casement', 'fixed', 'hinged';
For 'garden' in Field 1 the multiple choices might be 'lawn', 'concrete', 'hanging'.
Could the experts please advise.
To illustrate what I have in mind and would wish to do:
Field 1 is populated by an entry selected from a drop down list giving a choice between 'door', 'window' and 'garden'.
Field 2 is a detail relating to the content in Field 1 and is best filled by using a drop down list of choices. BUT, the content of the drop down list needs to be tailored relevant to the intial choice selected in Field 1 as the choices for door, window and garden are different.
For 'door' in Field 1 the multiple choices might be 'front', 'back', 'patio';
For 'window' in Field 1 the multiple choices might be 'casement', 'fixed', 'hinged';
For 'garden' in Field 1 the multiple choices might be 'lawn', 'concrete', 'hanging'.
Could the experts please advise.