I am new to Access and have created Tables, Forms and Queries so have some familiarity with the program. However, I am not certain it is an effective or efficient way to handle my wants/needs.
I want/need a more efficient inventory management database process.
I make or buy a product that I use in my personal and professional life. The finished product has many different combinations of the components.
I buy 4 component types each having many different part IDs and assemble them into the desired finished-product configuration.
I track both component and finished-product quantities.
I have created a table for each component and one for the finished product.
I update the 5 tables via forms and update queries.
My question is: will my inventory system be more effective/efficient if I were to create a single table for both components and finished products?
I would like to create a Single Batch form to update the quantity of each component used and the quantity of finished product added.
Any input would be appreciated.
Thank you in advance.