Add a column to table from another table

Z

ZBC

I have a table I wish to modify by adding a '#' field so that I can then
relate it to other tables which contain a '#' field.
The table ... I will call it Table1, currently has a 'name' field but no
'#' field.
I eventually want to delete the 'name' field from table1.
I have another table which carries the unique relationship between
'name' and '#" ... I will call it Table2.
How can I use Table2 to add the '#' field to Table1? ...
'Name' and '#' currently have a one for one relationship.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
One-to-One Table keys 9
Setting column width in a table with a macro is not working 0
Create a chart from a table in word thats dynamic 0
comparing table values 1
Unable to display values in 2nd list box from 1st list box selection 2
Crating User Form to Add Names 1
Re-Seed in SQL Server 11

Top