Hi, I need a simple inventory database that should NOT handle In/Out transactions. It should only be updated every day with the current amount from the user. 

My Article table should look somewhat like this (ProdID,Description,UnitID,Price) (UnitID,Type) this should be kg, liters etc Articles should be updated from a form Daily stock take, this is where I have the problem. I know how to create a table and do a stocktake for every article ina dropdown from a form. However from a user perspective having to use the dropdown for each article and then submitting before moving to the next is not ok. 

 What I would want is something that looks more like a spreadsheet with all articles in column A and the user inputs all quantities in column B. Of course I would want to have a date and location attached to each stocktake. Will this type of input methid be feasible?