Hi all,
I'm currently creating an inventory system database for my company. the company i work for is a manufacturing company that builds kits for cars. I've currently created a very basic inventory system which works well i.e when a kit is processed it automatically adjusts the stock levels. but now i need to add in that when a kit is processed it not only adjusts the stock levels for the kit but it also adjusts the stock levels for all the individual parts that go into making a kit.
I knew the way i had to go about this was to create a junction table which i did and off that built a form with a sub form in it to input the appropriate data. now that all the data has been input I'm a bit uncertain how to tackle my problem.
So ultimately what i need help with is how do i use the data that i have input to record all the parts when processed.
Attached are how i created the junction table and the forms for reference.
Any help or resources that i could read up on would greatly appreciated.
Cheers,
Hek
I'm currently creating an inventory system database for my company. the company i work for is a manufacturing company that builds kits for cars. I've currently created a very basic inventory system which works well i.e when a kit is processed it automatically adjusts the stock levels. but now i need to add in that when a kit is processed it not only adjusts the stock levels for the kit but it also adjusts the stock levels for all the individual parts that go into making a kit.
I knew the way i had to go about this was to create a junction table which i did and off that built a form with a sub form in it to input the appropriate data. now that all the data has been input I'm a bit uncertain how to tackle my problem.
So ultimately what i need help with is how do i use the data that i have input to record all the parts when processed.
Attached are how i created the junction table and the forms for reference.
Any help or resources that i could read up on would greatly appreciated.
Cheers,
Hek