https://www.infopathdev.com:443/forums/46.aspx For questions concerning issues in the integration of SharePoint and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/74840.aspxThu, 02 Feb 2012 07:36:07 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:74840mattpalmgren0https://www.infopathdev.com:443/forums/thread/74840.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=74840<p>&nbsp;I have a list with two columns, Title, and Document ID</p><p>I have a document library with the standard document library fields, and a calculate field called Document ID.&nbsp; The name of each document starts with a 5 digit number, so the calculation just grabs those first 5 characters.&nbsp; Each item in the list can have one or more related documents in the library.</p><p>I want to be able to go to the list, click on an item, and have a form opens that shows the related documents from the document library.&nbsp; I want to be able to open the related documents from the form.</p><p>I figured if I created a new calculation column in the document library that concatenated the static URL to the library, http://www.sitename.com/subsite/libraryname/, and the document name, documentname.docx, into a single URL = http://www.sitename.com/subsite/libraryname/documentname.docx, and placed that on the form, I would be able to click the hyperlink and it would open the document.&nbsp; But it doesn&#39;t.&nbsp; I have tried various different calculations, including trying to call the internal document library document ID, but nothing works.&nbsp; Sometimes Word will open and give me a corrupt contents error, or just a blank page.&nbsp; I know the documents are not corrupt because I can click on them in the library and they open just fine.&nbsp;&nbsp;</p><p>Has anyone been able to accomplish something like this?&nbsp; It seems like it should be pretty straightforward. <br /></p>