Click file name to open pdf

I have documents (pdf) in dropbox. The filenames are in a db and listed in a grid. I want to be able to click on the filename and have it open the pdf. It seems to me this should not be as difficult as I am making it. What is the most efficient way to do this?

Make label and put it on your grid.
Call it SELECT
Put this on your On Record Event

{SELECT} = “<a href=“javascript:void%200” class=‘scButton_small’ onclick=“window.location.href=‘pdf_path_herel’+’?var1=”.{field_var}.”’;" > SELECT";