If the total stock is reach 1 means it generate alarm or msg

[prabhu]

Hi everybody i prepared a simple DB for my stocks.If the total stock is reach
1 means the computer gives an alaram(or)msg when i open the database or that
stock table

 

[pietlinden]

Hi everybody i prepared a simple DB for my stocks.If the total stock is reach
1 means the computer gives an alaram(or)msg when i open the database or that
stock table

what about in the AfterInsert of your form? You could grab the
StockNumber, and use Allen Browne's QuantityOnHand calculation, and
return the value somewhere. Then if it's less than your threshhold,
pop up a messagebox or write to a table or whatever. The solution is
on his website. www.allenbrowne.com