Linking 2 tables together

[ablib]

I'm trying to set something up, that I have seen work before (in other databases), so I'm sure it can work. Keep in mind I am very novice at this.

I have Table A that has a column that contains numbers of employee ID's. Also in this Table is another column that is (currently blank) for the employee name.

In Table B, I have 3 columns: EmployeeID, First Name, Last Name. The information in this table doesn't change (often).

I want the employee ID column from table A to be able to find the Employee Name in Table B, and update the Employee Name column in table A, as the information is entered.

I'm using Base to connect to a Microsoft Access database.

I hope this makes sense. Any help is appreciated.