Create an Indirect Lookup Relationship

Add an Indirect Lookup Field

An indirect lookup relationship is a new field type introduced with Salesforce Connect. It links an external object to a standard or custom object in the same way that a regular lookup relationship links standard or custom objects. In this task, you link Orders to Accounts based on their Customer ID fields, resulting in a new related list on the Account page.

  1. From Setup, type External Objects into the Quick Find text box. Click External Objects. Select Orders.
  2. Next to the customerID field, click Edit and then click Change Field Type.
  3. Select Indirect Lookup Relationship as the data type, and click Next.
  4. For the Related To value, select Account and then click Next.
  5. For the Target Field value, select Customer_ID__c and and click Next.
  6. Enter 18 as the field length. Leave the other options with their defaults. Click Next.
  7. To make the field visible to all profiles, select the checkbox next to Visible and click Next. In a real production setting, you would carefully analyze who should have access to order data.
  8. Leave all the checkboxes in their default state and click Save. A new Orders related list is added to the Account page layouts.
  9. Check your work! Click the Accounts tab, and click Go to view all accounts. Click any sample account to see its details. Scroll to the bottom to view a list of orders.
    List of Orders related to a particular Account
  10. In the External ID column, click an order number to see that order’s data. Note that only metadata—the layout or schema of the external tables—is synchronized into Salesforce. The data itself is read dynamically in real time. It is never duplicated into the Salesforce environment.
Keep learning for
Sign up for an account to continue.
What’s in it for you?
  • Get personalized recommendations for your career goals
  • Practice your skills with hands-on challenges and quizzes
  • Track and share your progress with employers
  • Connect to mentorship and career opportunities