Help with an update query??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a main table that I need to add information from another table. There
is a common field in both tables and I want to update a field name in the
main file from the other table. i.e.

common field: Ven_id

Main Table: ven_name
Second Table: ven_name

I want to take all of the names from the Second Table and add them to the
Main Table. I have tried an update query but nothing was done, so I
obviously did it wrong. help.....
 
If you are trying to add records to a table, you are not updating. You are
appending.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I have a main table that I need to add information from another table. There
is a common field in both tables and I want to update a field name in the
main file from the other table. i.e.

common field: Ven_id

Main Table: ven_name
Second Table: ven_name

I want to take all of the names from the Second Table and add them to the
Main Table. I have tried an update query but nothing was done, so I
obviously did it wrong. help.....
Click to expand...

Three questions:

Ok, you did something wrong. What did you do? We can't help you fix it
unless you tell us what you did! Could you post the SQL view of the
update query?

Secondly: do you really want an Update query (which updates values in
existing records) or an Append query (which would add new names which
do not exist in the Main Table)?

Most important: WHY would you want to store Ven_Name redundantly in
this main table? You can (and should) link the two tables by Ven_ID to
display the name; there is rarely any good reason to copy the name
into a second table!

John W. Vinson[MVP]
 
Back
Top