Hey Everyone
I need some help in building an Inventory program. What i need to do is take an order that would subtract quantities from the database. That way when the level hits the reorder level i would know to reorder the product. I am using access 97 with VB5. I would like to know if a SQL could be used or something else is out there that i Do not know about. I have smoked my brain on the easies way to do this, but i have not come up with anything. Any ideas let me know.

Thanks in advance

Altecjjf