Insert Data in One Table from Another Table

  • Thread starter Thread starter Toria
  • Start date Start date
T

Toria

I have a master database. One of the fields is called Sales Rep.

I have a separate table with the sales rep info and a BAN number. I would
like to take the sales rep table and have it put the sales rep name into the
master table based on the BAN number. I can't tell if this is an update or
append query or something else?

Thank you!
 
It would be an update query but your master table must also have the BAN
number so the query will know which record to update with the sales rep name.
But why bother having a master if you are not going to use it as master?
Just join the two table on the BAN number in your queries so the name will
always match.
 
Yes...so obvious. Thanks, Karl.

KARL DEWEY said:
It would be an update query but your master table must also have the BAN
number so the query will know which record to update with the sales rep name.
But why bother having a master if you are not going to use it as master?
Just join the two table on the BAN number in your queries so the name will
always match.
Click to expand...
 
Back
Top