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.