How to update Qty in Stock from an Invoice when selected.

[tim_tims33]

Hi,

I'm trying to refine my Invoice system, although i'd love to update my Stock table with the 'Invoiced amount'.

I select the StockID (or in this case 'UniformID') using a lookup. My thoughts are how best to update the stock quantity after this invoice is issued.



Here's one way i've been thinking... Could i use the AfterUpdate event of the UniformID to run an update query? But would that be wise?

Here's the screen dump of what i'm developing...

Any advice/guidance would be appreciated

thanks

t

[pbaldy]

See here for an argument against it:

http://allenbrowne.com/AppInventory.html

though his setup is more complicated than is often needed. I'd simply subtract sales from purchases to get quantity on hand.