Bill Of Material Set Up

Thanks in advance for any help on this issue. 

I have created a Sales Order Table and an Item Table. I select Items on the Sales Order, this is working fine. 

I would also like to create a Bill Of Material for Assembly Items which would simply be a list of items from my Item Table. I would then like to sell these assemblies on Sales Orders. To pull from the Sales Order the Assembly needs to be an Item (I believe). However, on my Bill of Material Table I will need (2) connections to the Item Table, (1) for the Assembly Item and (1) for the part Item. You can't have multiple connections between tables? 

Any insight as to how this is typically done. 

Thanks all. 

Any news here... I need that too... :-)

I am looking for this function to automate Assembly process in which, once assembly process completed child parts stock to get reduced as per the BOM available in the connected object.

Thank you.

I have the same question. Iam following in hope to find an answer.