Database connection SELECT stmt based on user input

Hello all,
 
I am new to the Adobe world. I am trying to create a form that loads employee information based on user entered data. I have the form setup in LifeCycle with a database connection, and I currently am using the bind to connect the specific fields to the dB fields, but I am starting to think I will need to update them via a script. The connection works. I am wanting to run a SQL SELECT statement when a user enters an ID into a text field, with the onBlur/LostFocus/Changed event. If the load is successful I want to populate fields on the form, last name, first name, address, etc. Is there any way to do this in LiveCycle or any Adobe product? The end result that I am trying to achieve is a PDF file that an employee views on our intranet, enters an employee number, fills in the missing values, then prints the page, rinse and repeat as needed. Hopefully later we will move to digital signatures, but that is later. I am hoping to not load the entire dB user table into memory when the PDF is loaded by the user.
 
Thanks in advance,
 
Josh