CFSelect to populate Textfield from Database

I have successfully created an INSERT form page. Now I wanted to create an EDIT/UPDATE page where I will query the information in the textfield when the user selects a name from the dropdown list.

Here's the process:

1. CFQuery from the database

2. Populate the Names in the drop-down list using CFSelect

3. Once the user select a name, it should automatically populate the textfields(firstname, lastname, etc.)

How will I do this?