I know someone has asked this but I didn't see a response so .... Can you do nested lookups in forms - I want to do something as follows

I want to create a form that has two dropdown lists ( say Industry Sector  and Industry Sub Sector )
The values of Industry Sub Sector should be displayed dynamically based on my Industry Sector selection.
 
For example suppose my Industry List is { "Energy", "Healthcare" } and my Industry Sub Sector List is {"Oil", "Pharmaceuticals", "Health Care Equipment & Services" }
 
If I select "Healthcare" as my Industry , then "Pharmaceuticals" and "Health Care Equipment & Services" should show up  in my Industry sub sector list and "Oil" should not.

 

And vice-versa if I select "Energy" then "Oil" should show up - not the other two.

 

This is a simple example with two Industries but the list can grow to many industries and each industry having many subsectors.

 

Any replies much appreciated.

 

Thanks,

Aarti.