I have a form, that once the user chooses a name, I want it to automatically fill in information from the query onto the form.
<CFQUERY datasource="myds" name="employees" blockfactor="100">
ORDER BY SortName asc
And the form just looks like this:
Name: Drop Down box with names from the above employees query
Agt ID: Blank Box (this is where I want the agt ID from the employees query to populate automatically when the user chooses a name from the above box.
Is there any way to do this?