So I have a DB that is used to track jobs with the job # being the primary key in the following format 2001-45 for example 2001 being the year of the prject and 45 being the 45th job of that year. In the record I'd like to link to project documents like drawings and such.
Now the plan is to have all the jobs files store on a network drive with a standardized file path format eg \\pdserver\folder1\2001-45\drawings with the only changing variable being the job number (records primary key). Is it possible to have the hyperlink feild automatically point to the file address without the user manually searching through the file tree? Can the job number be a linked variable in the hyperlink address?
I tried putting this as my default value for the feild \\pdserver\folder1\[Job Number]\drawings but all I get is a -1 value in the field not thwe actual link