I have a database that has 1300 rows and I need to create hyperlinks for the docuements associated with each record. The record has a project_ID which is unique and the document filename is equal to the project_ID plus a string of letters. They are all pdf files in particular folder on a shared drive. Filename and path examples are as follows:
Project_ID = 0ST1234
Filename of Document = 0ST1234OTFO.pdf
UNC = J:\SDT\APTT\0ST1234OTFO.pdf
I want to know how I could generate hyperlinks for all these records in which the project_ID is used in the path.
I would like to display the the link as the filename. Also, I would like to know how I can quickly update this in case the files are moved to another folder.