Reply to thread

Message: [QUOTE="Lynn Trapp, post: 2556506"] You will need to add a ParentID field to your inventory table. Each item in the assembly would have the InventoryID (or whatever your primary key is called) of the assembly in the ParentID field. You would have to have a record in the inventory table for the full assembly. InventoryID Description ParentID 101 Helmet Assemblly 102 Batter Helmet 101 103 Face mask 101 104 Chin strap 101 It can get a lot more complicated than that, especially if a particular part could be used in multiple assemblies, but this should get you started. [/QUOTE]