Auto Populate fields in Access Table

[chegra26]

Is there a way to auto populate fields in tables based on the criteria of other fields.
For example, I have a list of employees and when I select the employee ID from a lookup table, is there a way to get all the other employee information in the other fields to auto populate.
For instance when I select the employee ID, I want the employment date, years of service and salary of auto populate.
Thank you

 

[Joe4]

Never store in a table fields that which can be calculated on-the-fly! In can undermine the data integrity of the database and eliminate the dynamic nature of it as well.

Just join the two tables together in a query, and return all the fields you want to see.