How to display many-to-many relationships

[Lancaster]

Hi,

I'm using 5.2 Community and I have the following situation:

One Contact has multiple Accounts.

Display of this information is somewhat funky:

In the contacts list view I get an entry for each contact-account relationship, so for contact X who is a contact for Accounts A & B I get two entries.

In the contact detail view "account" field I only ever see the first of contact A's accounts.

Having contact X 1 time in the list view for each account he's on is ok, but I'd like to see a list of his accounts on his contact details page. Is there any way to do this through the designer tools, or do I need to get under the hood. If so, where do I locate the hood release mechanism (I'm comfortable with all the underlying technologies, just down know what the proper way to get at them is)?

TIA,

Tom

[Lancaster]

actually, since some pieces of contact data are stored in the relationship with the account (Title, for example), it would be sufficient that each link from the contact list view take you to the contact detail for the relationship with the given account. Is this possible?

TIA,

Tom