Hi all,
I am currently trying to build a database for the company I work for. I need the database to track our stock from suppliers and distribution records to our offices and private clients.
The difficulty is that each stock can have a different cost and said stock could either go to one of our offices, or to a private client at which would be sold for more then cost price. To begin with I only added the cost to a product when it was distributed. However when I need to do a stock check on 'what's left on the shelf', there are no cost attributed to the stock so I can't get a figure of how much money is sat on 'the shelf'.
My Database currently consists of 6 tables - Product/Stock/Distribution/Supplier/Private Client/Offices.
Any help would be hugely appreciated as the more I look at it the more confused I get...! If you need to me explain more about my database and/or explain my issue more clearly then please just ask me.
Thank you in advance
mccadam