Using 2 data points (EmployeeName, EmployeeLocation) I want to search for EmployeeName(s) in one textfield while displaying filtered EmployeeLocation(s)results in a multi-line textbox below it. I have the EmployeeName and EmployeeLocation data already in a table:
ID EmployeeName EmployeeLocation
1 TIM JONES CUPERTINO, CA
I use this dynamic auto-complete.js located here as the search field:
[url]http://www.codeproject.com/jscript/jsactb.asp
I modified it so that it uses a query to create the array of EmployeeName(s):
customarray = Array(
<%PrintJavascriptArray “dsn=myDSN”, “SELECT EmpName FROM bplookup”%>
);
Here is my search form:
<input name=”EmployeeName” id=”actb_textbox” autocomplete=”off” >
I have an empty textfield below that:
<textarea name=”textfield” rows=”5″></textarea>
And what I am trying to accomplish is to be able to start typing a name in the search field while displaying the EmployeeLocation results in the textarea below.
Any suggestions?