Hello all,
Currently a bit lost and any help would be greatly appreciated.
Background:The company i work for makes and sells kits which contain lots of individual parts. What I'm trying to achieve is an inventory system which records the number of kits sold and all of the individuals parts used in said kit.
What I'm having trouble warping my head around is how I'm meant to link the individual parts to the kits.
My current set up is:
tbl_kits;
Kit ID-Autonumber
Kit Number- Short text
Description- short text
Supporting Part ID- Number
Supporting Part Quantity Required- Number
Kit inventory level- number
tbl_Supporting Parts;
Supporting Part ID- Autonumber
Supporting Part- Short text
Description- Short text
Inventory Level- Number
Any guidance would go a long way.
-Hek
Currently a bit lost and any help would be greatly appreciated.
Background:The company i work for makes and sells kits which contain lots of individual parts. What I'm trying to achieve is an inventory system which records the number of kits sold and all of the individuals parts used in said kit.
What I'm having trouble warping my head around is how I'm meant to link the individual parts to the kits.
My current set up is:
tbl_kits;
Kit ID-Autonumber
Kit Number- Short text
Description- short text
Supporting Part ID- Number
Supporting Part Quantity Required- Number
Kit inventory level- number
tbl_Supporting Parts;
Supporting Part ID- Autonumber
Supporting Part- Short text
Description- Short text
Inventory Level- Number
Any guidance would go a long way.
-Hek