You could definitely set up a script where you compute the file path (not just the name) to each file from this job number and then use insert file with the "store a reference' option specified. Double clicking such a container field if a) it is NOT optimized for interactive content and b) does not have external storage specified in field options will open that file in your systems default application for PDF files.
But you could also use the same path with Open URL (at least this works in windows) to open the file without using a container field.
Either way, you might find the info and demo file located at this thread to be useful as it can help you determine the precise file path text to use to refer to one of your files: Exploring the use of a $Path Variable in Scripts
I just tried this with the Open URL script step. I specify the url with this calculation
"\\myserver\public2\job_scans\" & Job Ticket::Job Number & ".pdf"
to set up the path. When I try to close the calculation it highlights the '.' before pdf and I get a warning stating "This number can not be evaluated". How do I added the .pdf extension added?
The problem is the back slash characters, not the quoted file extension. In a calculation, "next \"word\" in quotes" evaluates as:
next "word" in quotes
To get actual back slashes, you have to double them in the quoted string.
Works perfect now!