Update a table with information from another table

[Miked]

how do I get names from a table to appear on another table. I need to have
names from an employee roster to appear, and be updated on a table with
additional information. I linked the tables, and I tried to create an update
query, but it does not imput the employee information into the new table.

 

[Rick B]

You don't.

You should never store the same data in two tables. What if an employee
gets married? Do you want to go fix two tables?

This scenario is the whole point of a relational database. You can select
an employee and pull data from multiple tables to a form, query, or report.
There is no need to have it in both tables.

Rick B