How do I add invoicing to my inventory database?

[Guest]

We downloaded a template for inventory management from office.microsoft.com
and it has worked well, but we do not know how to add invoicing into our
database. We have a basic understanding of forms, tables, reports etc but
not how to set up table relationships or how to create an invoicing table
that would do what we want (subtract from on-hand inventory counts based on
our product ID number).

 

[Albert D. Kallal]

We have a basic understanding of forms, tables, reports etc but

not how to set up table relationships or how to create an invoicing table
that would do what we want (subtract from on-hand inventory counts based
on
our product ID number).

If you can create the tables and relations, then likely you can make the
inventory work without even having to write any code.

I not 100% clear as to your "in-house" expertise level here, but you might
have to bring in a consulting to help you with this step.

Having said the above, if you are looking for some tables designs, try
downloading my sample quantity on hand database here:


http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

There is a inventory stock example. (download that..and use the customer
form to view/see a order). you will note that if you add, or increase (or
decrease) the quantity of a item used, then when you run the report...you
will notice that the quantity on hand is reduced. And, the same shows when
adding a order.

All of the above screens (which are not very nice!!) where built by the
wizards. The main point of that download is to show that you can have
quantities etc. updated by ms-access, but in fact not have write any code to
do this.