Inventory Database

[KenshiroUK]

Hi all.

I could really do with some help on this. I'm trying to create an inventory Database, but don't really know where to begin. I have a stock table, a orders table linked to a text file. I have created a query using a sum method that takes into account the amount of stock we have left again what was ordered. However do I need create a query to update the amount of stock we have in with the sum numbers? I meant I don't always want to be manually updating the stock since we get a large amount of orders.

This brings me to my second question is there anyway I can set it so that I get just the days orders at the end of the day. Say from 8:00am to 4m based on time done and date done? This is really confusing for me, since I don't really know where to begin.

 

[jdraw]

Inventory management/Inventory Control/ Stock Control are complex applications. They can be difficult projects especially if there is a tie in to Financial Systems.

You say you don't know where to begin.

Do you have any experience in Database design?
http://forums.aspfree.com/attachment.php?attachmentid=4712&d=1201055452
Do you understand Normalization?
http://www.utteraccess.com/wiki/index.php/Normalization
Do you know what Entity Relationship Diagramming is, and why it might be important to you? http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip

Have you done a simple Google search -- say
https://www.google.ca/webhp?tab=mw#...046b852493b8aa&bpcl=38897761&biw=1024&bih=601

Have you seen the Microsoft Inventory management database template?
http://office.microsoft.com/en-us/templates/inventory-management-database-TC001018458.aspx

At some point you should read Allen Browne's article at
http://allenbrowne.com/appinventory.html

And here's a good reference when taking on a database development project:
http://www.rogersaccesslibrary.com/forum/uploads/5/12-Steps_to_Better_Databases.zip

So there's a few suggestions to help with where to begin.

Good luck with your project.