I work for a small restaurant and we need a way to be able to do weekly counts and receivings for our inventory.
This is what I have so far:


I have a list of all my inventory, their category, location, etc... I also have a table to where I would store the date, and the count information. The table has four columns: count date, item name, cooler count (all that's in the cooler), and bar count (all that's in the bar). The problem is, I can't find a way to bring up all the items from my main inventory table (the table with the names of my inventory, also where I update my new stock). I need to be able to see a list of all my inventory (probably with a query) and have all 306 items show up in the "item name" list in my count table. And once I input the actual amount of the inventory count, I need to be able to store it in my count table with the item name, amount, date, etc...