on delete add qtyOnHand again in product table

[khan]

I want QTY on hand to be updated when record in detail sale is deleted.

can any one help

[Trevor Best]

khan wrote:

I want QTY on hand to be updated when record in detail sale is deleted.

can any one help

You want to update a column that shouldn't be in your database anywhere.
This should be a calculation, calculate it whenever you need to display
it. Saving a caculation is troublesome as if you were to update this at
the delete of a detail record, if an error occurs then it may not be
updated then you'll have items that don't add up to your total.

[khan]

hey trevor, I am still confused, can you explain a bit please man. i do
update when i enter sold qty in saledetail table, and I do it on before
update event of the form but i dont know how to update when you delete
a record.

[Trevor Best]

khan wrote:

hey trevor, I am still confused, can you explain a bit please man. i do
update when i enter sold qty in saledetail table, and I do it on before
update event of the form but i dont know how to update when you delete
a record.

You don't. You get rid of the qtyOnHand field from your database. Never
store a total.

e.g. to get a sum of the Qty field in the detail...
If this is a textbox in header/footer of your subform, set it's
ControlSource to:
=Sum(Qty)

In the main form, it would be something like:
=DSum("Qty","tablename","FKfieldname=" & [PKFieldname])