I would like to create a feature called "For More Information" and I thought using Custom Tables would be best suited. However, my particular need requires a joined view of two tables which does not seem possible?

Here is my example:

Contacts table
ItemID
Name
Email
Phone

ContactsDocuments table
ItemID
ContactsItemID [links to Contacts table above]
DocumentItemID [links to CMS_Document table]

Then I would like to list all the contacts on each document I create using the Data List for a Custom Table. But I need to join these two tables so I can get the Name for the current DocumentID being displayed. The reason for the join is that a contact can be represented on more than one Document.

What will get this working?