Hey guys and gals I am having a hard time figuring out how to automatically
populate a text box based on what the user inputs in the field above.


When they pick an associate DMS_ID, I would like it to populate associate last
name as a text box . They are both in the same table and same row. As it stands
now I can get the info into the area but as a drop down box only and neither of
them linked. I want to make this as easy as possible so we can keep the errors
as low as possible.

I need to do the same thing with description and activity code but if someone
could point me in the right direction for one then I could figure out the other
I am sure.

Is this possible with Cold fusion or do I need to use something else?

Thanks.



<CFQUERY NAME="Getassociate" datasource="#datasource#">
SELECT dms_id, lname, fname
FROM user_02_master
where rating < 99
and semail = '#session.dms_id#'
order by dms_id
</CFQUERY>

<CFQUERY NAME="Getshift" datasource="#datasource#">
SELECT shift
FROM user_02_master
where dms_id = '#session.dms_id#'
</CFQUERY>

<CFQUERY NAME="Getactivity" datasource="#datasource#">
SELECT Act_no, Desc
FROM act_02
order by act_no
</CFQUERY>



<HTML><HEAD>
<TITLE>Supervisor </TITLE>
<cfoutput><LINK REL=STYLESHEET TYPE="text/css"
HREF="#webroot#includes/sos_style.css"></cfoutput>

<!---
<script language="JavaScript1.2">

function billingmail(form) {
theStr = form.BillingEmail;
if (theStr.value == "" || theStr.value.indexOf ('@', 0) == -1 ||
theStr.value.indexOf ('.', 0) == -1) {
return (false);
} else
return (true);
}

</script>
--->

<h2>Supervisor ProAcc Entry</h2>
<form action="/logout.cfm" method="POST">
<input type="submit" value="Logout">
<cfoutput>
<b>Logged in as: #session.dms_id#</b>
</cfoutput>
</form>
<hr>
</HEAD>
<BODY>
<!---
<cfinclude template="../includes/menu.cfm"><br>
<FONT size="+1">Detail Check/VAS - Accuracy Form</FONT> <BR>
Please enter (and verify, if related circuit order) infomation below. --->

<!--- Entry form --->
<CFFORM action="test2.cfm" method="post" name="Form1">

<TABLE BORDER=10>

<TR>
<TH>PRS Card Input</TH> <TH></TH>
</TR>

<TR>
<TD valign="top"> Supervisor ID:</TD>
<TD>
<cfoutput>
<cfinput type="Text" name="inspas_dms_id" value="#session.dms_id#"
validate="integer" required="Yes" size="24" maxlength="4">
</cfoutput>
</TD>

</TR>

<TR>
<TD valign="top">Associate DMS_ID:</TD>
<TD>
<cfselect name="dcassocid" query="getassociate" required="Yes"
display="dms_id" value="dms_id">
</cfselect>

</TR>
<TR>
<TD valign="top">Associate Last Name:</TD>
<TD>
<cfselect name="dcassoclastname" query="getassociate" required="Yes"
display="lname" value="lname">
</cfselect>

</TR>
<TR>
<TD valign="top">Description:</TD>
<TD>
<cfselect name="actdesc" query="getactivity" required="Yes"
display="desc" value="desc">
</cfselect>

</TR>
<TR>
<TD valign="top">Activity Code:</TD>
<TD>
<cfselect name="actcode" query="getactivity" required="Yes"
display="act_no" value="act_no">
</cfselect>

</TR>
<tr>

<TR>
<TD valign="top"> Hours:</TD>
<TD>
<cfoutput>
<cfinput type="Text" name="hours" value="" validate="integer" required="Yes"
size="24" maxlength="3">
</cfoutput>
</TD>

</TR>
<TR>
<TD valign="top"> Units:</TD>
<TD>
<cfoutput>
<cfinput type="Text" name="units" value="" validate="integer" required="no"
size="24" maxlength="6">
</cfoutput>
</TD>

</TR>
<TR>
<TD valign="top"> Activity Date:</TD>
<TD>
<cfoutput>
<cfinput name="activity date" type="text" size="24" maxlength="8"
required="no" validate="date">
</cfoutput>
</TD>

</TR>

<input type="hidden" name="dv11" value="0">
<input type="hidden" name="dv12" value="0">
<input type="hidden" name="dv13" value="0">
<input type="hidden" name="dv14" value="0">
<input type="hidden" name="dv15" value="0">

<input type="hidden" name="vdv11" value="0">
<input type="hidden" name="vdv12" value="0">
<input type="hidden" name="vdv13" value="0">
<input type="hidden" name="vdv14" value="0">
<input type="hidden" name="vdv15" value="0">


<!---
<cfoutput>
<input type="hidden" name="salespersonid" value="#session.loginid#">
</cfoutput>


<input type="hidden" name="EquipStatusID" value="1">


<!--- Field: ActiveEquipmentOrders.Notes --->
<TR>
<TD valign="top"> Notes </TD>
<TD>

<TEXTAREA name="Notes" cols=50 rows=5>None</TEXTAREA>

</TD>
</TR>
--->
</TABLE>


<P>
<!---
<INPUT type="submit" value="Input Record"> --->
<INPUT type='button' value='Submit' onClick='this.form.submit();'>


<!---
<input type="text" name="myfield"
onKeypress = "var keyCode = (event.which) ? event.which : event.keyCode;
if(keyCode == '13') {alert('Enter') return false; }">
--->

</CFFORM>


</BODY></HTML>


<!---

<form name="form1" onSubmit="return false">
<input type="text">
<input type="button" value="SubmitForm" onClick="document.form1.submit()">
<a href="#" onClick="document.form1.submit()"><img src="button.gif"></a>
</form>
--->