Dynamic Textfield

[thekbizo-cfnQdg]

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

[thekbizo-cfnQdg]

Help someone please

[Abhinav_Sharma]

If possible, you can use web service call to get this done. Tell if further help needed on web-service call.

Thanks.

-

Abhinav