Adding to JohnB
If possible, have an event, message box or some way of alerting you to show up when a quantity for an item gets below the required minimum level.  Have the event set up in such a way as to open (click a button) it's own table/form/report to get a printout from to hand to a purchasing agent to order buy. I can set up a warning flag overall for my products when they get below a designated level using a query but this effects all the items, not each item individually. I have over 600 different products and some minimum levels are different for each item.  This would greatly enhance or make an inventory control more powerful if possible.