SQL changes field to true if there is a match

[legos]

I have 2 tables, one is a table with items in stock and a second is a table with items that are on order. When an item that is on order is added to the items in stock i want to design a query that will change a value in the order list to true/yes so i know that the item was recieved. Both tables have a field called "ID" that can be cross referenced. The order table has an additional yes/no field called "received" so that the user can know if the order was recieved or not. How do you design this query.

Durible Outer Casing to Prevent Fall-Apart

 

[formerTexan]

legos,

See UPDATE QUERIES. Open a new query in design view and add the applicable table. Click on toolbar on the top and select the appropriate query type: Queries > Update.

Cheers
Bill