Can someone Help. I would like users to put their employee number on textfield,and automatically to pull data from database to fill the form.I would like to know the function I have to put under Employee Textfield.
I have the following SQL statement.
SELECT vchLastname,
vchFirstname,
vchKnownAs,
vchDisplayName,
vchEmailAddress,
vchWorkPhone,
vchHomePhone,
vchCellNumber,
vchFaxNumber,
vchEmployeeNo
-- vchLocationDepartmentDesc
FROM tblUser tUser
WHERE (bactive = 1 OR (bActive = 0 AND iNoOfAttempts > 0))
AND vchEmployeeNo = '$vchEmployeeNo'
ORDER BY vchLastName, vchKnownName
thanks help