Create an External Lookup Relationship

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 Details to Orders based on the Order ID field in both objects, resulting in a new related list on the Orders page.

  1. From Setup, type External Objects into the Quick Find text box. Click External Objects and select OrderDetails.
  2. Next to the orderID field in Custom Fields & Relationships, click Edit and then click Change Field Type.
  3. Select External Lookup Relationship as the data type, and click Next.
  4. For the Related To value, select Orders and then click Next.
  5. Enter 18 as the field length. Leave the other options with their defaults. Click Next.
  6. To make the field visible to all profiles, select the checkbox next to Visible and click Next.
  7. Leave all the checkboxes in their default state and click Save. A new OrderDetails related list is added to the Order page layouts.
  8. Check your work! Navigate back to the account that you were looking at before. Click an order number to view a new related list below the order data. Screenshot of the Orders Detail page for the 1025 order
  9. Click an External ID to see the line item’s data.


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!

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