Matt,
I think we need more info about your environment and your proposed project/database.
Here is an older draft picture that may be relevant to your requirement. Assembly is a junction table. FinalProduct would equate to your model, if I understand your post.
MajP's example allows for many...