Ok, so you are using a people picker in the form. In your other list with employees and departments, if the Employee field is a person or group column type, then you would be able to match on the account id to get the correct dept. Add a data connection to your list to your form, attach a copy of your form here, and I can help you.
Hilary Stoupa
