Hi Alan,

Thank you for your assistance.

I had an idea on how to create drop downs 1 & 2. The only reason i did not mention about it in my post was because i thought dependent lists worked differently. So I thought it was better to get help from drop down 1 itself.

Drop down 3 & 4 are very tricky and is out of my league and understanding. Hopefully you can guide me through with it.