Hope that you may help me with this one.
I am trying to build a system that will help my with inventory tracking. So far so good, and there are many great templates and tutorials out there.
HOWEVER, I haven’t figure out yet how to solve my issue: From time to time, employees take equipment from our warehouse for a specific project, and I want to keep track of everything.
I thought about making a table for each time someone takes something, and then finding a way to reduce the amount of available items from the amount of items that went out from our warehouse. but - I have no idea how to do that.
Making a row for each project is not ideal as well, because each project uses several items with different quantitates.
Any suggestions or tips?