Want to set a drop down box that does not repeat the same value despite that
value appearing in the list more than once.

Then once a selection is made from the 1st drop down list, the second drop
down box selection criteria changes.

ie. table a follows:
list 1 list2
commodities oil
commodities plastics
FX options
FX spot
FX longcall

1st list would have 2 options: commodities, FX - not repeated. User selects
"commodities".

Then 2nd drop down list automatically changes to contain only: oil, plastics
- as commodities was chosen in the 1st list.

Hope there is a way to do this, without setting up separate lists for each
possible combination?
Thanks, Tony