Dynamic combo box

I want to create a form that has two combo boxes and when the user selects the first combobox, the second combobox will dynamically change to follow the related data in the first combobox.

The from has data from two different tables whose data are related to each other

does anyone has a code for this ??

i have try several code using and javascript.

Does this helps?

http://probertson.com/articles/2005/10/03/dynamic-cfinput-label-2/

i am close to the solution and i hope for the success

Good luck man, let us know how it goes :)