Microsoft Access Update Field

[slim]

Hi,

Does anyone know if this is possible.

In a microsoft access 2000 table I have got various fields including employeeid, firstname, etc.

When I enter the employeeid in a row I would like the firsname field to update accordingly on its own, basically select the relevant information from another table where the employeeid matches.

Thanks

Slim