I tried creating a new lookup field (reference) in OrderLineItems object to reference OrderLineItemsExt object, But the question is how to make this relation to use ProductID as the key field rather than using SFDC object ID and which requires populating that reference field with other Object's ID?. I need to use the existing ProductID as key.
Example: Implementing a simple JOIN in treditional DBMS systems
Select Oli.ProductID, Oli.ProductName, Oli.MfrID, OliEx.MfrName,OliEx.GroupCode
From OrderLineItems Oli
JOIN OrderLineItemsExt OliEx ON OliEx.ProductID=Oli.ProductID
Any thoughts?.....
4 réponses
When you create a custom object you have to give it a Record Name. If you set it to Text and then call Record Name "ProductID", when you do a Lookup search of it on the OrderLineItems object, you are searching by the "Product ID".
