| | |
|
|
|
Inventory Databases |
|---|
| message from =?Utf-8?B?V1RP?= on 12 May 2004 |
I run the inventory for my small business. I have just started using access to help get my inventory management from paper to electronic format. I have orders come in and product going out. I have the products names and amounts in one table. I created another table to log my daily orders. Is there any way the connect the two. Say I have an order for 2 of product A going out...When I log that into my Orders table, I want it to automatically decrese the amount of product A by two..which is in the other table. Is there anyway to link tables like that? Make sense?
|
| Allen Browne replied to =?Utf-8?B?V1RP?= on 13 May 2004 |
Big question.
There are so many aspects to inventory, that there is no one-size-fits-all
solution.
In general, though, you need to create a solution that has verifiable
quantities, not randomly add and subtract from some number in a table. For
an introduction to the concepts, see:
Inventory Control - Quantity On Hand
at:
http://allenbrowne.com/AppInventory.html
|
| Kevin3NF replied to =?Utf-8?B?V1RP?= on 12 May 2004 |
You will need to write a little VBA code to increment the QtyOnHand field
when you receive, and decrement it when you sell.
|
|
Archived message: Inventory Databases (Microsoft Access Error Message)
