Having field automatically populate based on selection

[Kozbot]

Hello

I have a training log that has 4 tables, the employee table, the training course table, and the department table.

These tables all contain the names of employees, training courses, and department in one field and their respective ID codes in the other.

The 4th table is the actual log where the manager logs in who took the training courses. When the manager goes to select the employee name, course name, and department name is there a way not using VBA for the respective ID number to appear in the 4th table (they use the same field names and are related)

Thank you!

 

[Mihail]

These tables all contain the names of employees, training courses, and department in one field and their respective ID codes in the other.

Very bad setup. Post the database (2003 or 2007 version)

 

[Kozbot]

Very bad setup. Post the database (2003 or 2007 version)

http://i.imgur.com/aZQ32mD.png

What is bad about it?

 

[Mihail]

Now, after I see the pic, I can say that is not so bad
From your words and, maybe, due to my English, I've understand that in each table you have the same information repeted.

I say not so bad not that is good.
Again, upload the database and I'll tweak a little bit your tables and, of course, the relationships.
No need for records in the database but, if there are, will be better.