I am trying to create a single document library that links to documents in the same library in SharePoint 2010 Server. I've created a multi-value lookup column that references the same library to allow this behavior.
For simplicity, this document library has 2 fields: Item (text) and RelatedDocs (multiple value lookup). Ultimately, I'd like to have a 2-way relationship between these documents; So if an item is added/deleted in the RelatedDocs column, those documents in that multi-value column would be updated with the current document as well.
Since I have been unsuccessful in automatically updating those documents, I've tried adding a CQWP and DVWP in the Edit and Display forms to display all of the related documents for the specified document. In the CQWP I've added filters: RelatedDocs contains [PageFieldValue: Item] OR Item contains [PageFieldValue: RelatedDocs] but does not break up the multivalue RelatedDocs field.
For example, I have 3 documents: Doc1, Doc2, Doc3. I set Doc1 : RelatedDocs = Doc2 and Doc3. When viewing the details of either Doc2 or Doc3, I see Doc1 in the Related List/CQWP. When viewing the details of Doc1, I do not see Doc2 or Doc3 in the Related List/CQWP unless it is specified in the other items. It would not be manageable to create a link on both sides for every document. Is there any way that I can have the values in the RelatedDocs column appear in the Related List or CQWP?
I'd prefer to use SPD and OOTB functionality. Any suggestions would be appreciated! Thanks!