I have two different tables. Lets call the first one ‘Table A’. Table A has a list of documents and there is an attachment for each document. Table B has a field which has a dropdown of documents from Table A which the user selects. What I would like to be able to do is create a hyperlink that automatically opens the document (typically a PDF) for this field. I understand the prefixes/suffixes. My uploads end up under the ‘uploads’ folder. That being said, when I open the PDF under Table A, I get a large alpha numeric section of my URL. Looking under the server, there appears to have been some soft of temp folder created. DO I simply reference the uploads folder for me URL in order to get this to work?
JoeB7774 wrote:
DO I simply reference the uploads folder for me URL in order to get this to work?
Yes, just try.
Ok. I got the idea but I’m struggling on one part. I have a drop down which lists the attachment description. But when I enter the prefix of
“MYURL/uploads/”
The HREF adds the attachment description and not the name of the actual attachment. The attachment description makes more sense to display rather than the attachment name but I want the attachment name to be what gets attached to the URL. I end up with
“MYURL/uploads/Attachment Description” when i want the Attachment Name.
How do I pass the value of the attachment field (rather than the description).
JoeB7774 wrote:
The HREF adds the attachment description and not the name of the actual attachment.
That is because your HREF field is the attachment description field, you should use the attachment field instead. (Assume your attachment field stores the file name.)