Hello, I have to keep records for individual parts within an inventory. First, I will supply the sufficient background information:
There are roughly 1,000 parts that I will be keeping track of; some of which the inventory amounts change nearly every single day, and others which only come through the plant once. These parts are divided into three main categories: metallize, pad print, and paint.
As of now, I was planning on setting up some forms so that when a part comes in, the user can simply enter in a few fields of information that I will require for record keeping. I was planning on having the data go to one of three tables: 'metallize', 'pad print', or 'paint' depending on the type of part that it is. When it comes time to see the trail of a specific part, I was planning on having another form that will allow the user to pick the part number, and a report that shows every incoming/outgoing shipment for that part number back to a specific date.
Does this seem like a reasonable approach? If not, I would love to hear some suggestions.
P.S. I have already looked at the template for inventory that MS Access provides, but it has a surplus of options that I do not want. If anyone knows how to reduce this template, I could potentially do that as well.
Thanks!