I have a relationship where my product table contains raw materials, sub-assemblies, assemblies, etc. They are all called "products" with unique productid. I don't think it fits the BOM because a BOM consists of materials merging to create sub assemblies, merged to create assemblies, etc. I have a relationship where my product table co