i need serious help.i am a beginner using access 2007.I have 3 tables.<br>INVENTORY<br>SALES<br>SUPPLIER<br>I have created a an update query that deducts the qty amount after a transaction is made and update that value to the qty field in the INVENTORY table.Now i want to the database to warn me when the stock(inventory) level starts to run low.How in the world do i do this without having to use VBA?