Create Automatic Interchangable Hyperlink (1 Viewer)

[Zanatos]

I am attempting to creae a hyperlink to set into a table that is generated automatically by other information curently residing on the table, and with the ability to change the disc location.

The table I have created is an application that will name reports that I have in .PDF format. I put in the report title, date, inspectors, etc. and it gives me a unique name for the document. I then go to my document and name it what the application gives me. Now, we would like to have a link to that file that resides on the table, so if we look it up in the future we don't have to search any further, we can just click right there and go strait to it.

I know how to insert a hyperlink to get to the file, assuming it stays on the same directory. Our directories change fairly often (can go from C:/My Docs/File to E:/My Docs/File in a matter of a week), so I would like to know if there is a way to create a partial hyperlink that I can change the begining to whenever need be.

Any ideas or suggestions are greatly apericiated.

Thanks guys!

 

[Simon_MT]

There are two parts to locate the file.

1) The path
2) The file

The path stored be stored in a table so it can easily (globally) changed.
The File Name is make up of the components that make if unique.
Concatenate the two to get the file.

Simon