Can I use a query to insert a field in a table?

[ZBC]

I have a table (Table1) that I want to add a '#' field.
Table1 has a 'name' field but no '#' field.
I eventually want to delete the 'name' field from table1 and use the '#'
field for relationships..
I have another table (Table2) which carries a one to one unique
relationship between 'name' and '#".
Can I use a query and Table2 to add the '#' field to Table1?

 

[Bill Crawford]

Design a 'Make-Table' query using Table 2 and add the new field(s), from
expressions using table2 fields, to the query. Then, this make-table query
will over write Table1 with the fields you want and associated records.
Rememeber this overwrites the table fields and records in Table1.

 

[ZBC]

THANK YOU!

Design a 'Make-Table' query using Table 2 and add the new field(s), from
expressions using table2 fields, to the query. Then, this make-table query
will over write Table1 with the fields you want and associated records.
Rememeber this overwrites the table fields and records in Table1.