I would like to automatically generate the input of a form field. After I input a value in a related field in the form I want infopath to lookup the corresponding value in a table for the field i inputted and return it to the field I want to have automatically filled in.

Ex. I want to put in the employee number but then I want the program to automatically go get the employee name that corresponds to that number and put into another field on the form.