Hi

I am trying to alter the options available in a dropdown field based on the values entered in 2 preceding dropdowns.

So, for example dropdown 1 allows the choices "core", "higher" and "advanced", dropdown 2 has a choice from 10 values (e.g. general, acutely ill, cardiothoracic) and then dropdown 3's list depends on the combination of values from dropdowns 1 and 2.

That means Core-->General-->dropdown 3 choices will be different from Higher-->General-->dropdown 3 choices.

Can you give me any guidance on how to code this please. I have looked at some of the much more simpe examples but can't seem to manipulate them to work. I could if necessary change to 2 dropboxes by combining the 1st 2 but that would mean 30 options in the first dropdown...ouch.

I have attached the excel spreadsheet for the choices I am trying to code into the dropboxes.

Thanks

Andrew