Thanks,
KeAnne
<CFQUERY DATASOURCE="IESForms" NAME="TravelerInfo">
SELECT TravelerID, SSN, Deliver, PreferredName, LastName
FROM vwTravelerInfo
ORder by PreferredName
</CFQUERY>
<script language="_javascript_">
<!--
var aryTravelers = new Array();
<cfoutput query="TravelerInfo">
aryTravelers[aryTravelers.length] = new Array(#TravelerID#, "#SSN#", "#Deliver#");
</cfoutput>
//--->
</script>
<script language="_javascript_">
<!--
function DisplaySSN(aryTravelers) {
var objTraveler = document.all("idTraveler");
var objSSN = document.all("idSSN");
var iTraveler = objTraveler.options[objTraveler.selectedIndex].value;
for (var i=0; i<aryTravelers.length; i++)
{
var aryX = aryTravelers[i];
if (aryX[0] == iTraveler)
objSSN.value = aryX[1]
}
}
//-->
</script>
<CFSET HoldIDExists = #IsDefined("TravelID")#>
<cfif parameterexists(TravelID)>
<cfset LoopCondition =2>
<cfelse>
<cfset LoopCondition=1>
</cfif>
<!---new record--->
<CFIF LoopCondition is 1>
<CFSET ButtonText = "Save">
<cfset NewRecord="yes">
<cfset Traveler="">
<cfset SSN="">
</cfif>
<cfform action="" name="TravelProcess"
<select name="Traveler" class="formfield" id="idTraveler" > <option value=""></option>
<cfoutput query="TravelerInfo">
<option value="#TravelerID#" >#PreferredName# #LastName#</option>
</cfoutput>
</select>
<cfoutput>
<input type="text" name="SSN" value="#SSN#" size="12" maxlength="11" class="formfield" id="idSSN">
</cfoutput>
</cfform>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]