Indirect Lookup Relationship Fields on External Objects
Use an indirect lookup relationship when the external data doesn’t include Salesforce record IDs.
Required Editions
An indirect lookup relationship links a child external object to a parent standard or custom object. When you create an indirect lookup relationship field on an external object, you specify the parent object field and the child object field to match against each other.
Specifically, you select a custom unique, external ID field on the parent object to match against the child’s indirect lookup relationship field, whose values are determined by the specified External Column Name.
If the external system uses case-sensitive values in the specified External Column Name, make sure that the parent object field is also case-sensitive. When you define the parent object’s custom field, select External ID, Unique, and Treat "ABC" and "abc" as different values (case sensitive).
External
ID and Unique attributes are available as
parent objects in indirect lookup relationships. If you don't see the desired object when you
create an indirect lookup relationship field, add a custom unique, external ID field to that
object.
- Account record (parent standard object) displays a related list of SAP sales orders (child external object) with matching customer IDs that aren’t Salesforce IDs.
- Contact record (parent standard object) displays a related list of social media posts (child external object) with matching social media handles.
