Stop sprinting to the computer.
You should be able to set up a secondary dataconnection connecting to the SQL database.
The secondary datasource will have 2 sets of fields 'Query' fields and 'Data' fields.
- Find the employee Id field in the secondary datasource Query set and put that on your form as a control
- Add a button with a rule to Query the secondary dataconnection
Add another rule to set the field in your Main datasource to the value from the secondary datasource Employee Name Data set field.
When an employee id is entered by the user into the first field and they press the button, the second field should populate with the name.
Hope this helps. :-)