oi Jillian!! <option value="#users.trainerid#">......</option>
-- Critz Macromedia Certified Advanced ColdFusion Developer <CFX_BotMaster Network="Efnet" Channel="ColdFusion" Blog="http://blog.ctzc.com"> ------------------------------------ Saturday, October 19, 2002, 8:48:05 PM, you wrote: JC> I have a bit of a problem... and I'm hoping there is an easy way to solve JC> it. JC> I have a dropdown that is populated like this: JC> <select name="trainers"> JC> <cfoutput query="trainers"><option>#users.fname# #users.lname#, JC> #users.city#</option></cfoutput> JC> </select> JC> So it provides a list of trainers, by name including the city they train in. JC> What I want to do is let my visitor choose from this list, but when it JC> passes the value, I'd like it to pass another variable #users.trainerid#... JC> instead of any of those other fields (fname, lname, city0. JC> How would I do this? JC> -- JC> Jillian JC> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm