inventory for assemblies and part of assemblies

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I am setting up an inventory system for our company. Just want to clarify
how I should set up our parts and assemblies. We have a wide range of
assemblies which consist of parts. Believe I need two tables or maybe three
one for the assemblies and one for the parts then link the two tables so
that each assembly can have multiple parts associated with them. Each
assembly needs to record how many of one part each consists of.

Not sure if I can make this work with just the two tables or if I need a
table in between which records the quantities of the parts associated with
the assemblies.

Hope someone can give me some thought and point me in the right direction

Thanks
Chris
 
Your belief you need three tables is correct!
TblPart
PartID
etc

TblAssembly
AssemblyID
etc

TblAssemplyPart
AssemblyPartID
AssemblyID
PartID
QtyOfPart
 
Back
Top