I know why I asked which table.
I asked a question Form 1 Shows a sale through a query Choose within the query 2 Tables 1 Items 1 Extended sales
I want to update table only items
And once again what table is participating in the game
as I can see there is no OnHandQuantity field on both tables.
it means that you generate the OnHandQuantity by Summing the Quantity from Received_details table on that particular Product_ID.
and subtract it to the sum of same Product_ID on the Sales_detail table.
you don't need to Update any table, you calculate the remaining balance on the fly.