Insert Data in One Table from Another Table

[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!

 

[KARL DEWEY]

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.

 

[Toria]

Yes...so obvious. Thanks, Karl.

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.