I have 3 objects order, order_lines and shipment_lines . So order has many order lines and many shipment_lines.
So I want to display order_lines and shipment_lines fields on a single related list on order.
In an attempt to make Orders as Junction Object, here's what I found:
I already have a Roll-Up Summary (COUNT Order Lines) on orders with a Master-Detail relationship with master as Orders .
On order_lines I have Lookup to Orders order_number__c
On shipment_lines I have Lookup to Orders shipment_number__c
In the end I created a different object Shipping_order to have MD with shipping lines and order lines(I don't prefer this). But now I have to show this table as related list in order.
Is there any possibility that I can add it to Orders object?
Thanks in advance!