Writing Report as HTML including field content as hyperlinks

[runkefer]

I have a database with three related tables. One table has a field that contains filenames of image files. The ultimate output should be an HTML table, with that field (call it "Image") that a user can click on and link to the image. This is not a database-driven web site or anything fancy. What I want to do is distribute a CD with a lot of images on it, and have an HTML index page that users can open in their browsers and have a guide to what image they want to open and look at.

In other words, the table would look like this:

Smith | Joe | 1936 | Wedding Photo | Image
Smith | Sam| 1942| Army Photo | Image

And "Image" would be a hyperlink to the contents of the field "Image" (e.g. XYZ1234.jpg). I'm not concerned about paths at this stage, as the CD will probably just have everything in the same folder.

I can easily make a report with all the correct columns except the hyperlink part. How do I do the rest?

TIA

[Aristo]

I have a similiar problem and need help very quickly.
I too a database in which one of the fields contains filenames of images. All images are in the same folder. In this case however, the ultimate output should be an openoffice writer file with all the images in it. I'm making a yearbook and wish to use mail merge fields.
The file should thus look like this:
............._________
Name....|..................|
Adress.|...{IMAGE}..|
etc........|..................|
etc........|_________|

The yearbook has to be finished next week, so I need help very soon.
Thanks very very much for any help in advance.

ps. excuse me for any spelling mistakes, I'm not a native English speaker
_________________
Not a native English speaker