Blank txtbox - allow user key in new values or select frm existing rec

[omoo]

I need a blank textbox which allow user to select a list of existing records in the database. But if the desired value is not in the database, the user can key in the new value in the blank textbox. This value is to be inserted into the database. I can use "select" to list the values and use "input" to create the blank textbox but I have problems putting these 2 together as one single box.

I am writing it in ASP but not sure if javascript can be implemented from this script?

Here is my code:

<form name="insert_subcon_ratings_records" method="Post" action="insert_subcon_ratings_records.asp" onsubmit="return validate_form2(this)">
<table>
<tr><td width=180><font color=red>*</font>Subcontractor Name: </td>
<td>
<select name="NAME">
	<%
	sql="select DISTINCT NAME from subdb_subcon_rating"
	Set rs = OraDatabase.Execute(sql)
	response.write ("<option value></option>")
	Do While Not rs.EOF
		IF Request("sc_name") = rs("NAME") THEN
 			response.write ("<option value="""&rs("NAME")&""" selected >"&rs("NAME")&"</option>")
		ELSE
 			response.write ("<option value="""&rs("NAME")&""">"&rs("NAME")&"</option>")
		END IF
	rs.MoveNext
	Loop
	%>
</select>
<input type=VARCHAR2 name="NAME" size="50">
</td></tr>
</table><br>
<input type="submit" name="submit_subcon_ratings_records" value="Submit Ratings Records">
<input type="reset" name="reset" value="Reset">
</form>

 

[manarth]

You can't combine an input and a select - it sounds like you want a kind of type-ahead-find...


Google Suggest does this quite well - it's implemented with Ajax.

---
Marcus
better questions get better answers - faq581-3339
accessible web design - zioncore.com

 

[cLFlaVA]

omoo,

here is my solution, as promised:

http://www.coryarthus.com/news/21/.

note: you will need to pre-fill an array using your ASP code, but once that's done, it should work as you want. let me know if you have any questions.

*cLFlaVA
----------------------------
[tt]I already made like infinity of those at scout camp...[/tt]
[URL unfurl="true"]http://www.coryarthus.com/[/url]