![Microsoft Access Control List Microsoft Access Control List](http://www.blueclaw-db.com/cic_inv_add.gif)
Hi guys, i have searched loads of threads to gather information and some ideas but i still can't quite find what im looking for. I need a stock/'inventory' control database. Something that records stock coming in, stock going out, who buys stock and the current stock situation. I'm not sure how the tables/relationships should be set up. I have attached one version of how it could look. What do you think?
The other way i was thinking of was having orders, order details etc. Whats the best way of doing it so that the stock qty gets updated etc. I want a stock database that doubles up as a sales database. When someone buys stock i want it to be subtracted from the stock quantity. When new stock arrives i want to log the new stock by adding (either more quantity to existing stock) or adding a new item. I want to keep track of orders placed with suppliers etc. What tables/relationships would anyone suggest?
Stock Control Database Theory and practice of database design. A guide how to create an MS Access stock control database and a free download. Software-Matters in Dorset are experts in MS Access database design and development. This donwload is a training tool only and not a finished product. Software-Matters are based on the borders of Dorset, Somerset and Wiltshire in the.
![Microsoft Access Stock Control Template Microsoft Access Stock Control Template](http://cdn.free-power-point-templates.com/articles/wp-content/uploads/2014/06/Be-on-Top-of-Your-Events-with-This-Access-Template.jpg)
![Microsoft Access Stock Control Template Microsoft Access Stock Control Template](https://i.ytimg.com/vi/Q3kvcXfXApM/maxresdefault.jpg)
![Microsoft Access Inventory Control Template Microsoft Access Inventory Control Template](http://cdn.free-power-point-templates.com/articles/wp-content/uploads/2014/04/Handle-Inventory-Management-in-a-Breeze.jpg)