Skip to main content
Topics#Lightning ExperienceKedar Mudhalwadkar's Question
Kedar Mudhalwadkar (Salesforce) asked in #Lightning Experience
Aug 4, 2015, 11:02 AM

External Lookup Relationship

Context of problem statement:

- I have Standard Account ex. United Oil and Gas, Singapore

- I have external objects PRODUCT_CATALOG__x and PRODUCT_TO_ACCOUNT_MAPPING__x (referred as PC__x and PTA__x resp in following discussion). These are basically MySQL DB tables with same name except __x

- PC has all the product offering ABC Pvt Ltd. sells to all Accounts (PRODUCT 1 TO 100)

- PC has columns such as ID (PROMARY KEY), PRODUCT_ID

- PTA has maping between Account and products sold to that account (ex. lets assume ABC Pvt Ltd. sells PRODUCT 1 and 2 to one of its accounts, United Oil and Gas, Singapore) 

So PTA in MySQL looks like:

AccountId                     Product_ID (FK to PC)

-------------------------------------------

0000sdsfhh                   1

0000sdsfhh                    2

Note *** 0000sdsfhh is SF ID for United Oil and Gas, Singapore

Here is my problem statement:

- I have created external lookup field on PTA__x to populate it with Product_name

How to achieve this?
1 answer
  1. Kedar Mudhalwadkar (Salesforce)
    Aug 4, 2015, 11:08 AM
    So my requirement is, target external object PTA__x whould look like:

    AccountId__c                     Product_ID__c                              Product_Name__c

    -----------------------------------------------------------------------------------------------------------

    0000sdsfhh                   1                                                         Product 1

    0000sdsfhh                    2                                                        Product 2 

    0000errffee                    1                                                        Product 1                    

    Note *** 0000errffee is some other account
Write an answer...
0/9000