Enter an employee name, and their company automatically populates in a table

[Access_Novice]

For now I am having users work directly with tables. I would like to have a column where the user can select the name of a subcontractor employee from a pull down list in the table. Then based on the employee they select, in an adjacent column called "Company" the name of the company that the subcontract employee works for would automatically populate in the table.



How can this be done? I believe I would need some sort of VLOOKUP function, just like they have in Excel.

[June7]

Users should not work directly with tables and queries. Can't really do what you want in a table. Use form.

Have a multi-column combobox that includes fields for employee info, including their company. An expression in textbox can reference columns of combobox to display the info.