Inventory Databases

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You will need to write a little VBA code to increment the QtyOnHand field
when you receive, and decrement it when you sell.



--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

WTO said:
I run the inventory for my small business. I have just started using
Click to expand...
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?
 
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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

WTO said:
I run the inventory for my small business. I have just started using
Click to expand...
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?
 
Back
Top