Running an update query with two linked tables

[Dankniseley]

Hi All,

I was wondering if it is possible to do the following or if there is another way to do what I am describing.

I have a master table with the following fields:
ID
Vendor
Part number
unit Cost
New Unit Cost --> which is blank
Lead tim
New Lead time--> which is balnk

I also have a responce table which has the same data fields but is only a very small subset of the mater table.


Each week I want to copy the response from the responce table to the Master table


I am joining on ID and want to update the master table with New Unit Cost and New lead time from the Response table.

I am using the join to only update value that I have recieved a response for.


Any Ideas?

 

[Norie]

Try something like this

UPDATE [Master Table] RIGHT JOIN [Response Table] ON [Master Table].ID = [Response Table].ID SET [Master Table].[New Unit Cost] = [Response Table]![New Unit Cost], [Master Table].[New Lead Time] = [Response Table]![New Lead Time];