ive got an online system which allows people to enter info into a database about an absence request they have - at the same time this emails the person in charge of absences.

The form is setup now but to make it easier i want to alter the "Name" and "email" fields so they require no filling in ie - a staff members name will be chosen from a drop down list (ive done this bit fine) and then once this is done the relevant email for this person is automatically placed in the email field. This bit i am struggling with - anyone any ideas how this can be done??

Thanks!

PS: ive done this system using asp pages

I believe you can do this by using DHTML, PHP or Javascript. If you can the answers might be here:
www.dynamicdrive.com
www.javascriptkit.com
www.w3schools.com


Mik

thanks for that mik!

Ive come up with this too:

function mail()
if firstname.value="Gary Rodgers"
then
emailfieldname.value="grodgers@wickersley.net";
else if
firstname.value="Paul Worsnop"
then
emailfieldname.value="pworsnop@wickersley.net";
end if
end


%>

but this makes the browsers come up with the following error message:

Microsoft VBScript compilation error '800a03f9' 

Expected 'Then' 

/AbsenceForm/Absence.asp, line 24 

if firstname.value="Gary Rodgers"

whats wrong with my code???

Woody

You "If Condition Then" needs to all be on one line. You can't span multiple lines of code with one if statement. (without using the _ feature)

Hello Woody,

Like wbmstr2good stated, the Then has to be on the same line as the If. Also note that Else If in vbscript is one word, you do not end the line with ; and you must end the function with End Function. So your code should look like this...

<%
function mail()
    if firstname.value="Gary Rodgers" then
        emailfieldname.value="grodgers@wickersley.net"
    elseif firstname.value="Paul Worsnop" then
        emailfieldname.value="pworsnop@wickersley.net"
    end if
end function
%>

This is all assuming that you are trying to run the code on the server and not the browser. Seeing things such as firstname.value makes me feel you are trying to either run this on the browser (for which you should use javascript and therefore my code above is all wrong) or you are hoping that firstname.value on the server will set that value on the form, but it doesn't work that way.

I hope that makes some sense .