I have 6 objects. All have lookup relation between them Object A has lookup to object B which inturn has lookup to object C. [A-->B -->C ] Object C has lookup to Object D and object E. C --> D C --> E
I need to access field data from object A to E.Name.
I have query like select A__r.B__r.C__r.E__r.Name from object A
The child to parent should work upto 5 levels deep. However This is not working. Could you please help?