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

  • 1
  • Question
  • Updated 3 months ago
  • Answered
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. 
Photo of Neftali

Neftali

  • 70 Points

Posted 3 months ago

  • 1
Photo of Kunal Bhat

Kunal Bhat, Employee

  • 1,002 Points 1k badge 2x thumb
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