ScottMusich, what server-side scripting are you using?? Coldfusion, ASP, CGI??
If its coldfusion, then something like: <input type="textfield" name="somename" value="#firstname#">
This will have the value read from the dB, just make sure the onChange is called.
The following example will load a name into the textfield depending on what the drop-down selection was:
<!-- This script will pass a value from the drop-down choice to the textfield. -->
<html>
<head>
<title>Passes Value From the Drop-Down Choice To the Textfield</title>
<meta name="author" content="Ketan V. Mehta">
<script language="javascript">
function displ() {
//if the forms element is 0 (the first one) then return false; do nothing.
if(document.myFORM.valu.options[0].value == true) {
return false
}
else {
//otherwise, place the appropriate <option value> in the texfield from the drop-down menu.
document.myFORM.textfield.value=document.myFORM.valu.options[document.myFORM.valu.selectedIndex].value;
}
return true;
}
</script>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<table border="0" cellspacing="0" cellpadding="0" width="75%">
<tr>
<td width="100%">
<form name="myFORM" onClick="return displ();">
<select name="valu" size="1">
<option value>Choose One</option>
<option value="MT001">MT0001 | Copper Cable Shield 1</option>
<option value="MT002">MT0002 | Copper Cable Shield 2</option>
<option value="MT003">MT0003 | Copper Cable Shield 3</option>
</select>
<input type="text" name="textfield" readonly>
</form>
</td>
</tr>
</table>
<p><font color="#D3342C" size="2" face="Verdana">Select a value for the drop down
and watch as the appropriate <option value> is placed into the checkbox.</font></p>
<p><font color="#D3342C" size="2" face="Verdana">For instance if <strong><option
value="Some Text Here">Click Me</option></strong> is selected,
then the value of the option (Some Text Here) is placed in the textfield.</font></p>
</body>
</html>
Reality continues to ruin my life...
