How to create a dynamic link to a pdf file from existing DataAssist Results page

I have an existing DataAssist Search/Results page (one page). One column of the results table provides a dynamic link to a pdf file. I can get a static link to open the pdf file, and can also get a dynamic link to open one file, but need it to open different pdf files for each result.

When setting the parameters for the dynamic link, it asks for a detail page. Tried having it go to the results page, but didn't work. Tried adding a Detail page using DataAssist Pages, but don't know how to tie it to the existing results page. Is a Detail page even needed just to open a pdf file?

File attached.

No a details page isn't needed. Just create the results page and have it display the pdf location. Then you can go in and update the results page afterward to turn that into a link instead.

For each product I created a link in its Db column for the pdf download, which works but seems clumsy.

Would like to have just the image name in the Db and create the link dynamically on the results page. Is this possible? I've tried creating a dynamic link, but get a 'can't be found' error'.

File attached. Site viewable live at PM.

What code did you use for the link when you had the problem? You should be able to hard code the rest of the url and get just the name of the file from the database.

I've used this one created by clicking on the folder icon and selecting the Db binding: <?php echo $row_WADAProd['TDS']; ?>

Also tried this one: <a href="images/tech_data_sheet_download_icon.png">

You would do something like:

Also tried this one: <a href="media/pdf/<?php echo $row_WADAProd['TDS']; ?>">download pdf</a>

That way you put the path to the pdf files in manually and then just get the name of the file from the database.

This post has been deleted.