Hello Everyone,
I'm fairly new to access, have searched and searched for how to do what I am needing to do. Im hoping someone can help or point me towards a resource that could help.
Heres what I need:
The company I work for has inventory at our physical location (our shop) and we also have inventory on trucks. I need to track the inventory in the shop and trucks so that when items get below a certain preset level I can run a report to find out how many of each part I need in each location. Create purchase orders and receive the inventory to whichever location I need it at. I would like to at some point be able to track where the parts are going.
I feel like I am not being descriptive enough but I can not think of another way to explain what I need. Any help would be so greatly appreciated.