Hi all, I'm looking for some advice/suggestions. My work are currently wanting to implement a new stock management system, as at present, it's all done manually by counting stock and inputting into a spreadsheet, as a result we have no real time stock levels, no form of automation and essentially not in full control, a considerable risk to the business. I have been tasked with creating a project plan to implement a new system with the following two main objectives: 1. To have an automated stock ordering system (via an email to the supplier) if an item quantity falls below a certain level - but will likely require some more detailed rules. 2. To be able to get an instant snapshot of quantities of all items. I can think of loads more things that we could introduce but at present, the business just wishes to achieve the above as it is hoped that it will dramatically reduce the amount of man hours required and allow us to gain some form of control. The manager who has assigned this to me is quite technical and has stated he would like the above to be achieved in a database structure using SQL. I have very little experience in SQL, I'm fairly proficient in Excel and have used Access a little bit, but clearly this is probably out of my level of expertise so obviously in my project plan, under resources I will state I will need someone who is proficient in SQL. I do believe a report is created every time for a new job which states the materials required, so I'm thinking this can be taken from the stock quantities, and when we order stock add to the quantities. Anyway, I'm just looking for any suggestions of where to start, questions to ask, tools to use etc. Thanks in advance.