I have tables called "estimates", "line items", and "items". Estimates have line items which are displayed through a portal on the estimate layout, each line item is an item used in that particular estimate.
I would like to be able to bundle some items together into an "assembly" and have those items related to the assembly be displayed through the same portal as the line items.
So individual items, and all items related to an assembly would be displayed through the same portal, all of which are related to the estimate.
I can't figure out how to do this. It doesn't seem to fit a scenario where I would use a join table or a self join.
Can anyone provide some guidance?