Solved

Is it possible to join a custom and standard MDA objects?

  • 6 July 2018
  • 1 reply
  • 28 views

Hi Everyone,



I would like to join a custom object to the standard company object, so I can use the company's object fields in a report. Also, I tried to "enable lookup" the field that I want to use in the report, but I can't find the custom object, see attached screenshot. 

icon

Best answer by kunal_bhat 18 July 2018, 10:49

View original

1 reply

Hi Neftali,



If you wanted to see the Company object's fields when you create a report on your custom object you would actually need to go about it the other way and enable the lookup on a custom object field. 



Go the Edit view for the field in your custom object that you want the join to be based on.



Then similar to what you've done above, "Enable Lookup" and then look for the Company object.



You can then select the field to join on (in your case the Vertical field in the Company object).



This will then give you the option to select fields from Company in your report based on the field that your join is based on.



Hope this helps!



Thanks,

Kunal 

Reply