Converting a query for use in a form

Hi everyone, I hope you can all help me. I want to take the information I get from a query and use it is a form as a dropdown select box. For example I want to pull the colors from a table and list them in a drop down box and then when a user selects a color it will pass the colorID for use in writing to another table. I hope that comes across the way I mean. :-( Anyway, I think I used to use something called wddx with java to do this when I was coding in ColdFusion. Thanks!! Kevin Rose Valley Soaps