I'm building an inventory management system and need to be able to replicate systems.  We have several systems that are made up of several boxes which each contain numerous component items.  I have three tables set up:

1) tbl_EndItem
2) tbl_Container
3) tbl_Item

tbl_EndItem and tbl_Container are linked with EndItem_ID
tbl_Container and tbl_Item are linked with Container_ID

I'd like to be able to replicate and entire EndItem to include all the Containers and Items.