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
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