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

  • Thread starter Thread starter ZBC
  • Start date Start date
Z

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?
 
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.
 
THANK YOU!

Bill said:
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.
Click to expand...
 
Back
Top