function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
praveen356praveen356 

Can we achieve two level record retrive in standard objects

Satish_SFDCSatish_SFDC
What is two level record retrieve?
Some more details would help.

Regards,
Satish Kumar
praveen356praveen356

there was three custom object like student,sport and library.
child parent hirarchy of that 3 objects is: Student(parent)---->(child)sport(parent)----->(child)library.

Now by using library object we can retrieve student object records this is called two level record retrieving.
In the same way can we achieve on Standard objects

Satish_SFDCSatish_SFDC
Yes, this is possible for Custom or standard objects. Infact you can go upto 5 levels up in the relations heirarchy.

Hope this helps.
Regards,
Satish Kumar
praveen venkatapraveen venkata

Can u be more specific?
I think more than 1 level  is not possible in standard objects, as we cannot create Master-Detail between standard objects.
Can we achive 5 level if we create Lookup field for 5 objects?

Satish_SFDCSatish_SFDC
The objects have to be related. It can be either through Lookup relationship or a master-detail relationship.

For eg: You can create a formula to go from
Opportunity Products > Opportunity > Account > Owner > Profile and so on.
All these are standard objects.

Regards.
Satish kumar