Sharepoint Cascading Drop Down

In sharepoint 2007 Custom List while adding new listitem, i want to populate the Customer Name in the dropdown based on the selection of Customer Category. The selection category column contain radio buttons, for each category.

Problem:

I have different lists,base on the selection of radio button i want to bind all the listitem from a particular list. Now the problem is how to access various List base on the selection. I tried it with work flow but it did not helped me, i decide to achieve using custom code, as it is in Newpage.aspx of the List, i have to deploy as custom web-part and i have to add functionality to it, that also not help me due to time constrain.

Solution:

After considering different type of solution i choose two option

1) Using javascript & CSS to hide the required control, (i.e) Based on my selection of the radio buttons field from the list will show up.

2) Develop custom Web part.

3) Using Cascading Drop Down instead of using radio button.

I feel using Javascript & CSS is not a good approch, so i decide to go with web-part at that time i got Cascading Drop Down article." Thanks to DataCogs."

CoolStuff

Source: http://kethare.in