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 Order to Accounts based on their Customer ID fields, resulting in a new related list on the Account page.

1. From Setup Quick Find, search and select External Objects.
   
2. Select Order.
   
3. Next to the customerID field, click Edit.
   
4. Click Change Field Type.
   
5. Select Indirect Lookup Relationship as the data type, and click Next.
   
6. For the Related To value, select Account and then click Next.
   
7. For the Target Field value, select Customer_ID__c and click Next.
   
8. Enter 18 as the field length. Leave the other options with their defaults.
   
9. Click Next.
   
10. To make the field visible to all profiles, select the checkbox next to Visible.
    
11. Click Next.
    Note: In a real production setting, you would carefully analyze who should have access to order data.
    
12. Leave all the checkboxes in their default state and click Save. A new Orders related list is added to the Account page layouts.
    Note: If the Orders related list is not visible on the Accounts page layout, try refreshing the page or adjusting the page layout: Setup > Object Manager > Account > Page Layouts > Account (Sales) Layout