I have 2 External Objects "Orders and OrderDetails" I want to create External LookUp relationship between "Orders and OrderDetails".
I read some where that "To create External LookUp relationhip/Indirect relationship parent should have a field with ExternalId and Unique features". If it is a standard/Custom object it's easy to edit the field and make as ExternalId and Unique.
When i'm trying to make a "ExternalId and Unique" for field in OrderDetails, there is no such option to check for OrderDetails, may be because of OrderDetails is an external Object.
1.But what can i do so that the field become Unique and ExternalId?
2.or else ExternalId and Unique need to be created in the External System(I mean in SQLServer) itself