ColdFusion & Forms

I am working on a ColdFusion form, and want to update a second form field based on the selection from a dynamically populated drop down list.

Drop down list is dynamically populated with lastname, firstname from a database.

Based on the name that is chosen, I want to "auto-fill" a second form field with another field from the same table in the db.

I've worked myself into a corner I think!! Anyone have any pointers for this?

Many thanks!

first solution:
make 2 forms. after the user selected a name, he will be forwarded to the one to choose the "second field".

Solution #2:
of course it would be much nicer to do it without reloading.
Problem 1: only works with JavaScript. if users have javascript disabled you have to offer the alternative above.
Problem 2: You can´t do JavaScript with drag-n-drop or coldfusion. Talk to a programmer.

if you go for way 2 and want to know the solution for problem 2, i´ll look it up. since there is so many people posting a question here and never returning, i will only answer again after you did

M.