Access does not have triggers, so you will need to have some code running
that checks the quantites at some point.
For example, you might use the AfterUpdate event procedure of the *form*
where orders are entered to calculate the quantity on hand of the ordered
item. Use DLookup() to find out the minimum order level for the product, and
then SendObject to fire off the email if it is below the minimum level.
The more basic question, though, is how you know the quantity left. There
are many aspects to that question. For an introduction, see:
Inventory Control - Quantity On Hand
at:
http://members.iinet.net.au/~allenbrowne/AppInventory.html
Of course, it still may turn out that you get false alarms. For example, if
your data entry operator accidentally typed 100 cartridges when the client
ordered 10, and saved the record, the email would be sent even if they
correct their error straight away.
