Take the 2-minute tour ×
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It's 100% free, no registration required.

With Self relationship you can reference the same object, at the same time you can create a lookup relationship and still refer to the same object. So when do you call a relationship as self vs lookup. ( I know using look up we can reference other object), but at the same time you can reference the same object as well.

So can someone please clarify when do you say a relationship is lookup vs self?

share|improve this question
add comment

1 Answer 1

There are only technically two types of relationships between objects in Salesforce, master-detail and lookup. Though in reality when coding and in the UI you'll find both have some common behaviours and ways in which they can be used.

So Salesforce does not technically require you to do anything different regardless if your lookup references another object or itself, both are the same field type, lookup. So the difference is more the use case your using the field for than it's type. Note that the Standard object Account uses self references to implement Account hierarchies, parent and child relationship.

This topic in the documentation Relationships Among Objects is a good place to start reading more, and i noticed also covers a cool use case of master-detail relationships relating to many-to-many relationships. Hopefully this sheds a bit more light on the topic for you, but if you need more feel free to explain a little more in your question about your use case.

Extract from the above linked help topic...

Relationships associate objects with other objects. For example, a relationship can link a custom object to standard object in a related list, such as linking a custom object called Bugs to cases to track product defects associated with customer cases. To view the parent and child relationships among standard objects, see the ERD diagrams in Data Model.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.