I'm creating a form in infopath which is linked to an sql database. Im trying to figure out the code that will be used to automatically assign a value in one field based on what was entered into another field. It would be similar to a vlookup in excel where a value is returned based on the corresponding value in another field. In this case I want to put the Employee Name in one field and i want the Employee Number returning in another field.