function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Anil Kumar H MAnil Kumar H M 

Does Multiple Self lookup is Recommended or not

Hi 

In my project, I wanted to store details of the same object in other records. Example 

I have an employee object. Where I want to store Manager and Technical Lead of an employee
Technical lead and manger details are in the same employee object. 

So should I go with 2 self lookup?. or should I go with Storing their ID in the text field and when I want any details of the manager or the tech lead.  I can query using the ID.

Which one is the best approach w.r.t performance, Quality  .? 

AbhishekAbhishek (Salesforce Developers) 
If you want to create a relationship between the Employee and the Manager or the Employee and the Technical Lead then I would suggest creating a Lookup for each as this will allow you to show which employees report to which manager/technical lead.

I hope you find the above information is helpful. If it does, please mark as Best Answer to help others too.

Thanks.