Achieve your business goals faster by unlocking our Salesforce Cloud Services.

Lookup Relationship

Lookup Relationship in Salesforce links two objects together but has no effect on deletion or security. Unlike master-detail fields, lookup fields are not automatically required.

When a salesforce lookup relationship is defined, data from one object can appear as a custom related list on page layouts for the other object. There are derived into 2 subtypes:


A special lookup relationship is available for only the user object. It lets users use a lookup field to associate one user with another that does not directly or indirectly refer to itself.

For example: You can create a custom hierarchical relationship field to store each user’s direct manager.


When an object has a lookup with itself, it is a self-relationship.


Many-to-Many relationships can be modeled using master-details relationships between any two objects. It allows each record of one object to be linked to multiple records from another object and vice versa.
To create a many-to-many relationship, simply create a custom junction object with two master-detail relationship fields, each linking to the objects needed to relate.

Primary Relationship:

It is the relation created first with any of the two master objects.

  • The object with which the relationship is created first is called the primary master object.
  • The detail and edit page of the junction object will use the color and any associated icon of the primary master object.
  • The junction object records will inherit the value of the owner field.
  • The sharing and security settings of junction objects will depend on the associated master record.
  • Deleting a record of the primary object will delete the associated records of the junction object as well.

Secondary Relationship:

The second master-detail relationship created with another master object.

  • The object with which the relationship is created first is called the secondary master object.
  • This relationship does not affect the look and feel of the junction object.
  • The security and sharing setting of the junction object depends on secondary relationships as well.
  • Deleting a record of a secondary object also deletes the associated records of the junction object.

Junction objects cannot be created as a master object in a master-detail relationship with another object as detail.

Let us now learn Lookup Filter and Schema Builder.

Our Recent Blog

Share This Post