• Articles
  • Tutorials
  • Interview Questions

What is Lookup Relationship in Salesforce?

What is Lookup Relationship in Salesforce?

Salesforce’s lookup relationship is essential in various areas, from easy accessibility to application security of software. To better comprehend this, let’s discuss it in more depth one by one.

Check out the video for the Salesforce Course

Types of Relationships in Salesforce

We have seen above what Lookup Relationship actually means in Salesforce. Now, it’s important to understand the types of relationships in salesforce since it helps you choose the correct relationship type for a scalable data model.

Let’s start now to have a better understanding of the various relationship.

  • Lookup Relationship

A Lookup Relationship in Salesforce is a loosely connected relationship that enables one-to-many connections between objects.

  • Master-Detail Relationship

A Master-Detail  Relationship is closely linked, which means that if the parent is removed, the child entries will also be deleted.

This is advantageous and quite useful. The parent record may manage child record properties like sharing and visibility that help the child record with the proper guidance given by the parent record.

  • Many-to-Many Relationships

In Many to Many Relationships, every record from one object can relate to several records from another object and vice versa can also happen in this type of relationship.

  • Self Relationship

Self Relationship in Salesforce allows us to construct self-relationships between items in Salesforce. A maximum of 40 self-lookups are permitted in this type of relationship.

  • External Relationship

In this External lookup relationship in salesforce, we can connect an external object to a parent external object whose data is kept in an external data source using external lookup relationships.

  •  Hierarchical Relationships

This is a type of relationship, which enables us to build a hierarchy of users within an organization, and is only available in Salesforce for user objects.

Check out our tutorial on Salesforce Tutorial.

What is a Lookup Relationship?

A Lookup relationship is a type of relationship that simply joins two things together such that you may “look up” one object using the associated elements on another object. There are two types of lookup relationships in salesforce that is: one-to-one and one-to-many.

Despite having no impact on deletion or security, this kind of relationship connects two objects. Lookup fields are not necessarily required, unlike master-detail fields.

In a lookup relationship, a field’s value is determined by the value of a different field in another object. Lookup Relationship is frequently employed when two objects need to communicate data.

When you define a lookup relationship in Salesforce, data from one object can appear as a custom-related list on page layouts for the other object. This is how the Lookup Relationship works in Salesforce.

This type of relationship can exist between two items that are either standard or custom or between two standard and custom objects.

Both the parent and the child objects in this kind of relationship have separate security controls and sharing settings. By default, the parent object has no influence over records. Thus, this is how the term “Lookup Relationship” works in Salesforce.

Interested in learning about Salesforce? Enroll in our Salesforce Training now!

Salesforce Master Course

How to create Lookup Relationship in Salesforce?

Let’s move further and see the various steps that will help you to get the proper guidance to create Lookup Relationship in Salesforce.

Step 1: Login or Signup to www.salesforce.com.

Step 2: In Salesforce, a user must go to Setup -> Build -> Object -> Child Object to create a lookup connection.


Step 3: Now go to Build then click on Create and then select Objects.

Step 4: In Object, we have to select the child object.

Step 5: Now go to Custom Fields and relationship and click the New Button.

Step 6: Select Lookup Relationship as shown below and click on the Next button.

New Custom Field

Step 7: Choose Related to Object label. Now select the Child object in this particular step. Then, enter the Field Label, Field Name and click on the Next button.

Step 8: Then set up the reference field’s field-level security. Ensure that all profiles can see the Field level of Security. Click the Save button now.

New Relationship

Step 9: Select the Page layout for the child object field and click on the Next button.

Step 10: Now the new window will open up that is Add custom-related list. Click on the Save button. Now we have successfully created a lookup relationship.

After establishing the lookup relationship, we have a question about establishing a Relationship Field in Salesforce. Let us see the various steps which are given below so that you can understand how we can create a Relationship Field in Salesforce with minimum steps.

Get 100% Hike!

Master Most in Demand Skills Now !

How to create a Relationship Field?

In Salesforce, Lookup Relationship fields may be generated in the same way as other custom fields. In addition to bespoke objects, regular objects can also have lookup relationship fields as it is added to them. Let’s look at the different steps to understand how to construct a Relationship Field.

Step 1: Go to System Setting then Click on Objects and Fields.

System Settings

Step 2: Choose the object for which the field will be created.

Step 3: Select Object Fields from the Object Management menu and click New Field.

Object Management Menu

Step 4: Click Next after selecting Lookup Relationship Field.

Choose a Field Type

Step 5: Fill in the following areas:

  • Related To: Choose the object type that you want your field to be associated with in the related tab.
  • Label for the Field: Type in a name for your new field. The same field name cannot be used twice.
  • Associated List Name: Give the related list name a name. You may get a list of the records you have relationships with on the associated tab.
Lookup Relationship Field

Step 6: If required, look in the Hidden box. Users won’t be able to see the field if Hidden is checked. When you need to hide data that you don’t want to destroy, use this tool.

Step 7: Click Save Custom Field.

These were the following steps that would be used to create the Lookup Field in Salesforce.

Advantages of Lookup Relationship

Although a Lookup Relationship has several benefits, we’d like to highlight the most significant ones here:

  • Between two items, Lookup Relationships establish relationships.
  • When one item is destroyed, no other object is also erased.
  • A maximum of 25 lookups are allowed for one item.
  • In the child’s record, the parent is not necessary.
  • It is possible to create a rollup-summary field in this relationship.
  • There are no restrictions on how to implement this relationship even the child objects shouldn’t contain any records.
  • If the lookup field in every record has a value, you may change a lookup connection into a master-detail one.

Want to ace the Salesforce hiring process? Intellipaat’s Top Salesforce Interview Questions are meant only for you!


Since we have seen in this blog that Lookup Relationship is the most well-known of all sorts of relationships, we have tried to explain the Lookup Relationship in depth so that you can have enough knowledge regarding this specific domain of Salesforce. Additionally, Salesforce is well-known in the IT industry, and if your objective is to launch a career in this area, you are on the correct route.

Come to Intellipaat’s Salesforce Community if you have more queries on Salesforce!

Course Schedule

Name Date Details
Salesforce Certification 01 Jun 2024(Sat-Sun) Weekend Batch
View Details
Salesforce Certification 08 Jun 2024(Sat-Sun) Weekend Batch
View Details
Salesforce Certification 15 Jun 2024(Sat-Sun) Weekend Batch
View Details