How to create a lookup relationship in salesforce


Below are the steps to create a Lookup Relationship as follows:

  • Login to Salesforce
  • Click to the Setup menu
  • Go to the Object Manager then go to Favourite or enter Favourite in the Quick Find Box.
Create a Lookup Relationship
  1. From Setup, go to Object Manager | Favorite.
  2. On the sidebar, click Fields & Relationships.
  3. Click New.
  4. Choose Lookup Relationship and click Next.
  5. For Related To, choose Contact. …
  6. Click Next.
  7. For Field Name, enter Contact, then click Next.
  8. Click Next, Next, and Save.


Table of Contents

How to create master detail relationship in Salesforce?


  • Only up to two master detail relationships are allowed for an object.
  • You can have only Upto three levels of custom detail levels.
  • We can’t create a Master-detail relationship when the custom object already contains data.
  • Each object is allowed to have one or two masters or up to 8 details.

More items…

How to relate contact to multiple accounts in Salesforce?

Here are the steps you will need to go through:

  1. Find ‘Report types’ in Salesforce Setup using the search bar.
  2. Add the details, as shown below (you can copy them from this page). Ensure that ‘Deployed’ is selected.
  3. Define which objects should be included in the report, and how they relate to each other.

How do I create a Salesforce account?

  • To create a community, from Setup, enter All in the Quick Find box, select All Communities, and then click New Community.
  • To see more information about a template, select it.
  • Select the template that you want to use.
  • Read the template description and key features, and click Get Started.
  • Enter a community name.

What are the different types of relationships in Salesforce?

  • When a record of the master object is deleted, its related detail records are also deleted.
  • The Owner field on the detail object is not available and is automatically set to the owner of its associated master record. …
  • The detail record inherits the sharing and security settings of its master record.

More items…

See more


How do I create a lookup relationship in Salesforce example?

To create a lookup relationship in Salesforce:Navigate to Create > Objects.Click Sertifi EContract under the Label field.Scroll down to Custom Fields and Relationships.Click New. The New Custom Fields and Relationship wizard opens.Select Lookup Relationship from the list, and then click Next.

What is lookup relationship in Salesforce with example?

Advertisements. A Lookup relationship involves finding value of a field based on the value in another field in another object. It is mostly used in the case of commonly shared data between two objects.

How do I create a self lookup relationship in Salesforce?

Create a Self Relationship with the Position ObjectFrom Setup, click Object Manager.Click Position.Click Fields & Relationships, then New.Select Lookup Relationship as the Data Type.Click Next.In the Related To picklist, select Position.Click Next.Change the Field Label to Related Position .More items…

How do I create a external lookup relationship in Salesforce?

Create an External Lookup RelationshipFrom Setup, type External Objects into the Quick Find text box. … Next to the orderID field in Custom Fields & Relationships, click Edit and then click Change Field Type.Select External Lookup Relationship as the data type, and click Next.More items…

Why do we use lookup relationship in Salesforce?

A lookup relationship essentially links two objects together so that you can “look up” one object from the related items on another object. Lookup relationships can be one-to-one or one-to-many. The Account to Contact relationship is one-to-many because a single account can have many related contacts.

How many Lookup relationships can you create in Salesforce?

You can have a maximum of 40 lookups on an object. You can have a maximum of two master details on an object.

What is the difference between master detail and lookup relationship in Salesforce?

The Salesforce lookup relationship has no relation with other records. It does not depend on any other objects, whereas a master-detail relationship has an association with other records. On the other hand, the lookup relationship is just a reference. It can be even blank or NULL.

When should you use a lookup instead of a master detail relationship?

A typical use of a Master-Detail would be the classic Sales Order and Sales Order Items objects. Lookups are generally for use where you may or may need to have a relationship between two objects (but not always). Lookups are generally used to reference commonly shared data, such as reference data.

What are the different types of relationships in Sfdc What are they?

Types of relationship in SalesforceMaster-detail relationship.Lookup relationship.Self-relationship.External lookup relationship.Indirect lookup relationship.Many-to-many relationship (junction object)Hierarchical relationship.

What is the difference between look up and external look up relationship?

Difference between Indirect Lookup and External Lookup In simple terms, an indirect lookup relationship utilizes either a standard or custom object as a parent, and an external object as a child. Now, in an external lookup, the situation is reversed: the external object becomes the parent record.

What are the two types of lookup relationships available for external objects?

Therefore, two special types of lookup relationships are available for external objects: external lookups and indirect lookups.

How do you create an indirect lookup relationship in Salesforce?

Creating an Indirect Lookup RelationshipGo to “Setup” and use “Quick Find.”Input the object name and select it.Click on the customer ID field.Click “Edit” and select “Change Field Type.”Select “Indirect Lookup Relationship” and click “Next.”Select “Account” in the “Related To” value and click “Next.”More items…•

How to create lookup relationship in salesforce

How to create lookup relationship in salesforce :- Lookup relationship in Salesforce is one type of Object Relationship in Salesforce. In our previous Salesforce Tutorial we have learned about how to create master detail relationship in Salesforce.

How to create lookup relationship in salesforce?

To create lookup relationship in salesforce user must navigate to Setup | Build | Create | Object | Child Object (Samples).


In this Salesforce tutorial we have learned about How to create lookup relationship in salesforce. In our upcoming Salesforce Tutorial we learn about How to create Many to Many relationship in Salesforce.

What is a special lookup relationship?

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.

How to model many to many relationships?

It allows each record of one object to be linked to multiple records from another object and vice versa .#N#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.

What is lookup in Salesforce?

Lookup is a type of Salesforce relationship that connects two objects together without affecting security and deletion properties. Creating an intermediary relationship between objects is possible by adding lookup relationships to standard, custom and external objects.

What is a lookup relationship?

A lookup relationship field connects a child object to a parent object. The relationship can be added to standard, external and custom objects for child records; and standard and custom objects for parent records. A child record with a lookup relationship contains a lookup icon which, when clicked, will display its parent record.

Why are linked objects not affected by each other?

Linked objects can be accessed either separately or jointly. This is to protect the data from accidental edits and deletions.

Add an External Lookup Field

An external lookup relationship is another new field type introduced with Salesforce Connect. This type links an object to an external object. In this task, you link an external object to another external object! You link Order Detail to Order based on the Order ID field in both objects, resulting in a new related list on the Order page.


Congratulations! In just a few minutes time, you integrated external data by configuring an external data source in Salesforce, linked external objects with standard Salesforce account data, and brought it all together in the Salesforce user interface, all without writing a single line of code! Now that’s data integration, lightning fast!

Verify Step

You’ll be completing this project in your own hands-on org. Click Launch to get started, or click the name of your org to choose a different one.

Why is an account to contact relationship one to many?

The Account to Contact relationship is one-to-many because a single account can have many related contacts. For our DreamHouse scenario, you could create a one-to-one relationship between the Property object and a Home Seller object.

What can you use a relational database for?

You can use them for things like creating management chains between users. When you start adding relationships between objects, remember that you’re increasing the complexity of your data model. That’s not a bad thing, but be extra cautious when you do things like change and delete objects, records, or fields.

What is the third relationship type?

Finally, you could run into a third relationship type called a hierarchical relationship. Hierarchical relationships are a special type of lookup relationship. The main difference between the two is that hierarchical relationships are only available on the User object.

What is hierarchical relationship?

Hierarchical relationships are a special type of lookup relationship. The main difference between the two is that hierarchical relationships are only available on the User object. You can use them for things like creating management chains between users.

What is a Roll-Up Summary Field?

A roll-up summary field is one that aggregates data from a child object to a parent object that share a Master-Detail relationship. Roll-up summary fields can use the COUNT, SUM, MIN and MAX functions. For example, we could use a roll-up summary field to display the total value (amount) from Opportunities on a related Account.

Salesforce Native Solutions

There are multiple ways of creating a roll-up summary field on a Lookup relationship using native Salesforce functionality, but the most powerful AND accessible way is to use Flow.

AppExchange Solutions

There are a number of app listings in the AppExchange that can do roll-ups on Lookup relationships, as well as an open-source tool.


Now you understand the various options available to you, don’t forget to take a look at our guides:


Leave a Comment