update query question

[lorac]

Is there anyway to run an update query and only one record is updated?

for example:

I have a product table that contain the quantity of plants on hand.

when there is a sale in the sales table the quantity in the product table should reduce.

When i run the update query however all records in the sales table are subtracted from the quanity field in the product table.

please help
thanks in advance

 

[GumbyD]

It sounds like your criteria is not set. Can you post the SQL for the query?

GumbyD

 

[lorac]

sure

UPDATE [Purchases Invoice Table] INNER JOIN [Product table] ON [Purchases Invoice Table].PNo = [Product table].PNO SET [Product table].QOH = [QOH]+[Quantity];