Dynamic Drop Down and Updation of database - Coldfusion - Advanced Techniques

[Student-Kav]

Hi everyone,

My requirement is that I have an update CF page where the names of all the
eomplyees is populated using a drop down box, which I have completed. But once
the user selects a particular employee from the drop down than all the other
fields in the form should be filled up with their particular detials aand the
user can than update it.

I am not able to understand as to how to populate the form fields once the
user selects a value from the drop down.

Any sort of help will be well appreciated

thanks,
kavin

[GeorgeWS]

you could us a frame and have the drop down like on the top and when something
is selected refresh the page below it with the info. I have been using the
cfform flash and you could do this on one page with no refresh; but you need
CF7 to do that.

[Dan]

Or you can use 2 forms on 2 pages. Form 1 on page 1 has the drop down list,
Form 2 on page 2 has the details for the selected employees.

If the number of employees is small, say less than a couple hundred, you could
select everything and use javascript/actionscript to populate the other form
fields.