I configured this earlier & am aware of this on high level but wanted to do this handson Project.
First Step – I created External Data source called OrdersDB using heroku URL provided in trailhead
Using Validate & sync, i synched two external objects Orders & Order Details.
Now on external object Orders, i changed datatype of customerid field from number to Indirect Lookup to account and target value to customerid. (Note: while installing the package, customerid text fied – EXternal + unique got created and values also got populated)
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.
Boom, the Account page’s Related List now has Order.
Now on external object OrderDetails, i changed datatype of orderID to External Lookup to order and target value to OrderID
An external lookup relationship is another new field type introduced with Salesforce Connect. This type links an object to an external object.We can link one external object to another external object
Boom, the Order page’s Related List now has orderdetails