Updating Quantities

Hi there

If i have one form (products)
And another one (products sold)
and i want to update (products) table field (stock on hand)
once i sell an item in the (products sold) table with the field (quantity)
how do i deduct the (quantity sold) from the (stock on hand)?

Thanks heaps
Jason