Thanks Roy,
Someone on another forum had pointed me to that same article. That's a lot of VB code but I would like to try and use it and go that way, except I have no idea how to add all that code to the database and get it to work. Can you give me a pointer on where to look for help on adding...
Thanks. I was able to get the units in stock to update with the update query, but am missing the piece of how to get the units to increase when restock occurs. Where should the restock entry occur? Afield in the inventory table or a seperate table. Will I need a different update query for...
I'm somewhat of a beginner this being my 3rd Access database, but I have the table structure good and all relationships tight. I have an orders table, orders details table, products, inventory tables. The inventory table has prod ID, Stock on hand, Reorder level and is joined to the order...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.