Help building orders database

[adenwalker]

I need to update my sales database system.
Basically, I need a table where i can store products, their suppliers and how much is in stock. I then need a table where i can add purchase orders which will increase the number in stock in the products table by how much was ordered and then an orders table which will decrease the amount in stock by the QTY purchased

Any ideas? If someone could design me a sample database showing the above then that would be most appreciated.

Thanks
Aden

 

[maxmangion]

Ideally, you should start designing the database yourself and then post your tables design so that someone will give you feedback on them.

I need a table where i can store products, their suppliers and how much is in stock

Do not put products and suppliers info, all in one table ... search this forum for normalisation.

then need a table where i can add purchase orders which will increase the number in stock in the products table by how much was ordered and then an orders table which will decrease the amount in stock by the QTY purchased

Do not work on this at table level, you should not be storing calculated fields in your tables ... work on this in queries / forms.

 

[adenwalker]

Here is the dbase

Attached is the tables. Can anyone help i'm totally stuck! Feel free to modify the database and post it back here.

deliveries: where stock received is added
products: where product details are stored
orders: where orders are stored
suppliers: where product suppliers are stored
Customers: where customers are stored.

Not got winzip on machine at the mo so database is here: http://n.1asphost.com/chickham/db1.mdb

 

[The_Doc_Man]

Wrong approach, Adenwalker

You are the only person who knows your business rules. Search this forum for normalization topics, inventory threads, and the like. Anything we do for you is guaranteed to be wrong.

Search for my posts over the last year. If it looks like a security post, skip it.