First of all... Could you edit your post so I (as well as other users) don't
have to scroll off the screen to read the post.
Next, Could you show us your SQL statement?
Finally, By the sounds of it you can just update the Quantity of Product num A
(or whatever product) but then you lose the meaning of the date stamp. It will
only show the last time a product was requested (and not necessarily pulled).
Sounds like you want to have a separate table One for the Overall quantities
and one for the orders.
Via Web @ http://www.mnetweb.co.uk/irc
Via IRC Client pgardner.net:6667