Automate hyperlinks?

[pa3329]

I have a database of chemicals and one of the entries is the MSDS number. I would like a hyperlink, pointing to the .pdf of the chemical, created when I enter the MSDS number. If the MSDS number is 1111 the .pdf file will be something like (\\servername\folder\1111.pdf). Is there a way to store \\server\folder\ in a string, append the MSDS number, and .pdf then store that in a hyperlink field. Any suggestions?

 

[IgorB]

Why do you use File Dialog box, prompting user for selection .pdf file.
Then pass parameter to the string. Search forum for File Dialog box.

 

[pa3329]

Why do you use File Dialog box, prompting user for selection .pdf file.
Then pass parameter to the string. Search forum for File Dialog box.

There are tens of thousands of chemicals being added so the more I can automate the better. One click saved equals close to an hour overall.

 

[IgorB]

Added to column in the table? Like you have already stored

1111
1112
1113
etc.??



Igor.