Re: Help with an update query??
- From: John Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 24 Oct 2006 16:51:52 -0600
On Tue, 24 Oct 2006 14:29:02 -0700, T Miller
<TMiller@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
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.....
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]
.
- Prev by Date: Re: time criteria in query
- Next by Date: Re: Trouble creating an Update Query
- Previous by thread: Re: Help with an update query??
- Next by thread: Trouble creating an Update Query
- Index(es):
Relevant Pages
|
