HELP - Creating a link/hyperlink to a set of tiff files on a CD

[Phil]

Hi, I have a table designed, there are over 1000 records and I need to create
a link/hyperlink from each record to a tiff file on a CD rom. I have one
column whose field name is the same name as the tiff file name (how will the
extension be read?). If I had to complete this task manually it would take
forever! Also I may need to add to this list in the future. Any help would be
appreciated

ALEX M1BNK has provided a solution(see below) which I have tried to no
avail. My programming Skills are limited so I would need the exact steps to
follow.

Any help would be appreciated.

************************************************************
The calculations above should form a hidden text box on your form, then
create an object, like a "look at photo" button maybe, right click it, and in
it's properties, look for "hyperlink address". Set that to be equalt to your
calculated field's contents

Alec

As you'll gather if you have seen any of my posts, i am no expert
(understatement of the year!) but I think what you want to do is this

Assuming you have a form, and the form will display the filename to the user
for him to click and view the file, then

filename=file & ".tiff"

will get you the filename bit, but you will need to add a path in there too,
so maybe

filename="D:\mydbase\myphotos" & file & ".tiff"

would be better. You can then simply format this calculated field as a
hyperlink. generating it on-the-fly like this keeps your database size lower
than storing it in a table, and thus makes it faster.

Thanks