Showing properties of related objects in view

Hi all,

I have 2 object types:

  • Customer
  • 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,

 Beat