Hello
Another new person trying to get started. I did a project for my senior design class in college. The project was to help a company keep track of their parts inventory. My team member did the access data base portion of the project and now it is not working and I work for the company we built the database for. Class is over, team members graduated and the database is full of code, and not even one relational connection between tables.
Anyway, the only way for me to save face is to build a new, simple one from scratch, this way I can manage / maintain it. I wanted to start with just a few simple SKU's and at most 2 parts for each SKU. My goal is to keep our parts department stocked with inventory. I know how to calculate the re order points based on the previous demand I have and can worry about a fast way to do that later. For now I just need to keep record of the parts being sent to customers and the parts coming in to replace those from the vendor, which I think I have in place, see attached beginnings of my database. Now I need to figure out how to create a query, and hence a report that shows current inventory levels and another query / report that shows which items have gone below the re order point. I have time to work this out step by step if someone else has the time to help me. Please help if you can.
joe.ise