I have 2 object types:
- Contact Person
On the customer there is single select drop down to specify the main contact person.
I try to create a view that returns the E-Mail addresses of all main contact persons.
Since in a view I cannot use properties from related objects, I am not sure how to create such a view.
I could save the E-Mail address of the main contact person on the customer object, but if I change the mail address on the contact person, the customer object wouldn't get updated. So this isn't a solution.
What is the correct solution to implement this? I would assume this is quite a common use case..
Thanks for help,