unique id match up on update query

[BLTibbs]

access 2003 on win xp.
I have a table [ISBNData] that is a linked table to a text file. I want to
run an update query to update another table called [InventoryTbl] with data
in the isbndata table. The main table has a unique id field called
"product-id". The [isbndata] table has a field that matches the "product-id"
called "ItemAttributes/ISBN".

What do I put in the criteria of the update query to update the records in
the [inventorytbl] where the [isbndata] table has records that match with the
ItemAttributes/ISBN field to the product-id field.

Currently, I have:

Like [ISBNData]![ItemAttributes/ISBN]

typed into the 'criteria' field of the query but it keeps asking me for the
parameter value when I run the query. What is wrong?

 

[Pat Hartman\(MVP\)]

Create a query that selects the columns you want to update in the
inventorytbl. Add the isbndata table and join the two on the appropriate
fields. Change the query type to update. In the UpdateTo cell of each of
the update fields, enter column names from the isbndata table in the
format - [tablename].[columnname] - the square brackets are important.

If this query is not updatable due to the fact that it joins a linked text
file with a Jet table, import the text file and create the same update query
but use the imported table rather than the linked table.

 

[tina]

first, suggest you make a copy of your db and work with the copy until you
get the Update query running correctly - that's always the safest route when
fiddling with Action queries.

in your query design view, add the [inventorytbl] and the [isbndata] tables.
link the two tables on the matching fields. then add the fields from
[inventorytbl] that you want to update, to the design grid. set the Update
To row of each field in the grid to the name of the field you want to pull
data from, as

[isbndata].[NameOfField]

hth