I have an excel file contains a table which has 2 columns : name of employee , department which he/she works in it
in infopath i have a form with 2 text boxes .I want when I fill out the name of employee in the one text box, the name of his/her department will be written automatically.
please help me...thanks