Custom tab report
I have created a custom tab under the contact workspace, added a relationship item(for a custom object) and inserted a custom report. The report shows employers of that particular contact, where there can be many employers. An employer is also a contact in the system. I want to achieve this: when I click on a record on that report, it should open the related contact workspace (of the employer). The current situation is that when I click on a record, it opens the custom workpace associated with the custom object.
Any ideas on how I can achieve this? Thanks.