"moving names" to another table

[yepwingtim]

"moving names" to another table

Hi im making a new table
How would I move the names from the old table to the new table?
I know its something with relationships how how would i do it exactly? thanks
________
M13aa engine

 

[statsman]

Sounds like a job for an append query.

Select your original table as the source. The append query will copy the fields you want to the new table.

 

[Pat Hartman]

You seem to want to strore the same data in two places. You should be storing the primary key of table1 as a foreign key in table2. That way when you join the two tables in a query on PK to FK, you will be able to select columns from both tables in your query.