AnsweredAssumed Answered

Salesforce Master-Child Relationship

Question asked by VinoMurugesan7581 on Apr 25, 2012
Latest reply on Apr 27, 2012 by ted.sager
I am trying to find the best possible solution for the following scenario

Lets say I have an Account table which is a master to Order table which in turn is master to Order Line table. Each Order line has a lookup relationship with Item table. Is there a way to bring in all the above details in a single operation. 

The solution that I tried is to Create an operation on the Order table (we have filtering conditions on the order table) from which Order line (child object )and Account(Parent object) table can be picked. But the issue is I cannot pick the Item relation which is a child of Order Line and grand child of Order. What is the best way to get the Item details in this scenario.