working with dropdown in sharepoint 2007

Currently working with dropdown column in the moss 2007.

my question is

I created dropdown column in a list, it has 3 options. Suppose if option1 is selected then the new field (let say a text box) should pop up, if option2 is selected the another new field (say a dropdown should pop up) and similarly for option3. How to make these things show up when certain option in drop down selected? should I need to code for it? Educate me! Article would 开发者_运维知识库be a great help.

P.S->> Our organisation isn't so keen in working with infopath, infopath is out of option. Can I code in sharepoint designer itself???

This isn't possible using only SharePoint out-of-the-box (OOTB). It would require building a custom solution. You would need to create a custom field for each option, that checks the value of the choice field and determines whether to hide itself based on that.