Trouble Linking a PDF in a Reference Field..

I have a dynamic page that displays information about an annual event called a “roundup” held by my car club. The information is held in a database. We have 40 years worth of events. I want to be able to click on a link or image in the repeater that will open the corresponding club magazine (PDF) file that is stored in another database.

  1. created a reference field in the “roundup” database and then populated the field with the corresponding issue of the magazine.

  2. created a “text field” in the repeater and connected it to the reference field which says its a PDF image

When I preview I get nothing there?

When that didn’t work I created an onClick event on the repeater item LOGO to

wixLocation.to( variable containing name of pdf image).

Runtime I get error “unsupported URL”… I have read the examples for reference fields and I am obviously missing something?

Thanks for any assistance.
JD

I replaced the text box with a Text Button and it now brings up a PDF… but not the right one. All the repeater items bring up the same oldest PDF file??