Inventory/stock control template or HELP.

G

Guest

Inventory/stock control template or HELP.
I have been playing with the standard inventory wizard template which deals
with ordering and selling single components well.
However I want to buy components from several supplies put them together in
a new product sell the product and subtract inventory from the individual
components stock levels.
I need to be able to define a product for example that contains 2 off
component (a) 1 off component (x) 6 off component (r) etc ect dispatch it and
reduce the relevant component stock levels.
Can anyone recommend a template or help with this.

Access 2003

Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inventory levels in stock control database 5
Modifying the Standard Inventory DB to allow for individual items? 21
Manufacturing Inventory Database 2
Looking for a template, or need advice on "Assembly Parts" db 1
Simple Stock Control Sheet 1
Inventory Control Problem 3
DB design, facilitates Double entries of internal transactions 9
Inventory Assembly/Sub-component problem (query) 4

Top