Can I hyperlink between items in 2 subreports? (1 Viewer)

I have created a main report with 2 sub reports. The first subreport contains the list of items and the 2nd sub report contains a series of spec sheets and dwgs for each item if the record has one.

The final report is usually sent to PDF format. Is there a way to create hyperlinks in subreport 1 for each item that link to the matching spec sheet in subreport 2?

Thanks!

Reports are not generally designed to be interactive

ridders said:

Reports are not generally designed to be interactive

Click to expand...

I'm beginning to see that in Access. I come from the web world where almost anything is possible but requires alot of coding. This feature is something i can do without.