How does a lookup field work in salesforce


In Salesforce, you can use a lookup field to associate two records in a relationship. For example, a user can associate a contact record to an account record using the Account Name lookup field. When editing a lookup field, the user must find the right record to associate.

In Salesforce, lookup fields allow users to associate two records together in a relationship. For example, a user can associate a contact record to an account record using the Account Name lookup field. When users edit a lookup field, they need to find the right record to associate.Nov 14, 2017


How to create lookup relationship in Salesforce?

How to create lookup relationship in salesforce?

  • Step 2. : -Selecting Related to Object. Now select Child object in step 2. …
  • Step 4. :- Establishing Field Level Security for reference field. Make sure the Field level Security is visible for all profiles.
  • Step 5 :-. Select the Page layout for child object field. Click on Next button.
  • Step 6 :- Adding custom related lists. Click on Save button as shown above. …

How to create a custom field in Salesforce?

  • Field Label: Type
  • Field Name: Type
  • Values: Select Enter values, with each value separated by a new line
  • Enter the following values: Website Blog Event Podcast Group Job Other
  • At Required, select Always require a value in this field in order to save a record.

What is lookup relationship in Salesforce?

To add a LookUp field based on the value of another field:

  • Click on SetUp (Gear Icon) and then click on the Object Manager.
  • Click on the object you will be adding the Look Up field to.
  • Select Fields & Relationships and then click the New.
  • Select Lookup Relationship from the Data Type list and click Next.

What are lookup filters in Salesforce?

  • beta
  • deleted
  • deprecated
  • deprecatedEditable
  • installed
  • installedEditable
  • released
  • unmanaged

How do I use lookups in Salesforce?

Here are the steps to do it:Navigate to Setup.Select Develop, then click on External Objects.Select OrderDetails.Locate the orderID field. … Choose External Lookup Relationship as its data type. … Select Orders under the Related to value.Type 18 under field length. … Click on Next.More items…•

What is lookup field how is it used?

Lookup fields allow users to create relationships between different modules and enable users to display related lists of a record. You can use a lookup field to associate two different modules or pull up a list of records in another module.

How does lookup relationship work Salesforce?

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 does lookup filter work in Salesforce?

Lookup filters are administrator settings that restrict the valid values and lookup dialog results for lookup, master-detail, and hierarchical relationship fields….Lookup FiltersThe current record (source)The lookup object (target)The user’s record, permissions, and role.Records directly related to the target object.

What are advantages of lookup fields?

Creating a lookup field not only improves the meaning of data but helps avoid data entry errors by limiting the values that can be entered. A lookup field can display a user friendly value that is bound to another value in the source data table.

How do I make a lookup field searchable in Salesforce?

Choose Use a formula to set the new value and then click Show Formula Editor and select the “Insert Field” button to locate and select the desired field that you would like to make searchable. See Calculate Field Values With Formulas and Considerations for Field Update Actions for additional details.

What is difference between master-detail and lookup?

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.

How many types of lookups are there in Salesforce?

Clicking the icon opens a lookup search dialog that allows you to search for the record that you want to associate with the record you’re editing. There are two main types of lookups: standard and enhanced.

When should you create a lookup relationship?

You must create a lookup relationship when you create a custom button to run Sertifi from in Salesforce, whether you use Salesforce Lightning or Salesforce Classic. By creating a lookup relationship you ensure that data is accurately shared between two objects.

What is a benefit of using a lookup filter instead of a validation rule?

Validation rules and lookup filters achieve similar ends, but offer different advantages. Use a lookup filter: To improve user efficiency by limiting the number of available options in a lookup search dialog. To improve user efficiency by automating filters on lookup search dialogs that your users manually set.

How do I filter a lookup field in Salesforce?

Create a custom field with a lookup filter.From Setup, click the Object Manager tab.Click Case, then click Fields & Relationships.Click Contact Name, then click Edit.In the Lookup Filter section, click Show Filter Settings.Click the lookup icon. … Choose equals as the operator.In the Value/Field menu, select Field.More items…

What is dependent lookup in Salesforce?

A dependent lookup is a relationship field with a lookup filter that references fields on the source object. For example, you can configure the case Contact field to only show contacts associated with the account selected in the case Account Name field.


In the courier company, we have a delivery location which must be related to a delivery schedule. So we have a field “DeliverySchedule” in the object Delivery location that looks up for values from the other custom Object named “Delivery Schedule”. Let us now see the steps to create such a lookup relation.

Step 1

First we identify the objects and the fields which need to have the relationship. In our example, these two objects are Delivery Schedule and Delivery Location.

Step 2

Create a Custom Object named DeliveryLocation as we did in the previous chapter. In it, go to the tab fields and relationships. Click New → Custom Filed → Lookup Relationship. Choose the field type as lookup field and enter the details as shown below.

Step 3

You can verify the lookup relationship created by going to the schema builder and choosing the two objects for display.

Use Case

A company only sells in the United States. They have a rule saying that any Contact record that is marked as “Primary” must have a US Phone Number. We already have a Regex Validation Rule that enforces the formatting of the Phone Number:

Step 1 – Create a Custom Object and Import Records

The first thing we need to do is create a custom object to hold the acceptable values. We’ll call this Custom Object “Area Codes”. Because this is a Custom Object, we can give our Sales Operations Profile Users create permission on this Object.

Step 2 – Create a VLOOKUP Validation Rule

Now that our list of valid Area Codes are loaded into Salesforce and Sales Operations can add more as needed, we’re ready to begin building the VLOOKUP Validation Rules. The VLOOKUP Formula will be built in two parts, because it needs to do two things: find the matching value and then compare it to the current value on the record.

Follow Along with Trail Together

Want to follow along with an expert as you work through this step? Take a look at this video, part of the Trail Together series.


Lookup filters limit the records available in the lookup. A lookup filter can reference other fields on the same record (source); fields on the records of the lookup object (target); fields on the user’s record, profile, and role; and fields on records directly related to the target object.

Create a Lookup Relationship

Create a new Backup Agent field that looks up to the User object, editable by Support Users only.


Leave a Comment