Maintaining inventory

[Guest]

I have built a dbase that house information for parts (cost, manuf, part#,
etc.) we would like to have this dbase track inventory as well. Rather than
just having a QtyOnHand field that a user can adjust, we would like to have
them go through a form that asks "are you adding inventory" or "are you
depleting inventory" and then enter the # of parts added or depleted. That
entry would then adjust the QtyOnHand. But how? How can I accomplish this?
I have no doubt that it is a simple answer, it's just not coming to me.
Thanks!

 

[Guest]

Hi Kathy,

Take a look at MVP Allen Browne's sample, and see if you can apply it to
your situation:

Inventory Control: Quantity on Hand
http://allenbrowne.com/AppInventory.html


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

That is helpful. I was not planning on keeping separate tables for each time
inventory was added or allocated (this dbase doesn't need to maintain
invoicing info, etc.). I was hoping there was a simpler method, but maybe
this is the best way.

Thank you.