I have categories on my web site, and want some documents to display in multiple categories. I have created linked documents which work great.

I then want to display a list of what categories the document exist in, on the page of the document itself. So I related the documents together, and added two web parts to display the right and left sides of the relationship.

However, if this document exists in, say, 7 categories, then I'll need to create n-1 relationships, which seems a bit overkill for the problem at hand.

I found a macro dealing with linked documents. However, it only output the linked original document's node ID from the linked. If I were on the original document, it would not present me with the ID of the linked documents.

What's the best way to do this?

Or :), in the meantime, does anyone know what database fields connect the linked documents, so that I can put in a custom solution?