What is the best way to develop kits.

[Guest]

I would like to build a series of kits so that I can both track the number of
kits that are ordered as well as the components that make up each kit.

Example:

Kit 1 (made of of components A, B and C)
Kit 2 (made of components X, Y and Z)
Kit 3 (made of component A,Y, and D)

 

[Guest]

one table has all components only; a short unique IDentifier field (like A,
B, etc..) along with more complete description as needed per component record

a second table list kit IDs - and for each unique kit ID you list the
appropriate components from first table using just the short unique IDentifier