Setting Up A Lookup Field.

Ok I'll premiss this by saying it has been many years since I have done much with access so I have forgotten alot and alot of things have changed. However I have been using Dataease alot but switched companies so am back to access.

In dataease if I had a form called projects and that form had three fields (employee ID, employee first name, employee last initial) that pulled data from another table other than the projects table I would relate them via the employee ID.

projects form employee ID = employee form employee ID

then for the two other fields I would have them lookup their data by using the employee id.

projects form employee first name = if (projects employee ID = employee employee ID) then lookup employee employee first name.

And the same for the last initial.

The question is how do I setup for fields for first name and last initial to do the lookup in access.

Employee ID Table
Employee ID #
Employee First Name
Employee Last Initial

Project Table
Employee ID (linked to employee id table)
project id
project name
project discription
project start date
project end date

project form
project id
project name
project discription
project start date
project end date
employee ID (must match employee table employee id)
employee first name (read only field that looks its data up from the employee table based on employee id)
employee last initial (read only field that looks its data up from the employee table based on employee id)