I am trying to make a field that will display images from a folder.

I would like it to lookup the image file name based on the value of a different field.

For example, if the database were of different types of fruit, one of the fields might be "FRUIT_TYPE," and its value might be "CHERRY." Is there a way to use the "FRUIT_TYPE" field value "CHERRY" to access and display and image file named "CHERRY" from a set of images?

FileMaker Version: Dev 7

Platform: Mac OS X Panther

Yes, you can create a calculation like this:

"image: " & relative path to file

Blobbo.zip

This would solve my problem as well, but I can't get it to work!

"The file cannot be found:ImageName.jpg"

The relative path must be wrong... but try as I might, I can't get it fixed.

Any suggestions for this newbie?

Filemaker 7 - Mac OS X 10.3.3

Thanks in advance, Chris

relative paths work like in internet browser:

../images -> one level up, then folder "images"

images -> folder "images" in same folder as Filemaker db

/images -> absolute path to a folder "images" directly on top level of your startup disk

calc would read:

"image:" & "../../images/" & filename &".jpg"

However, it is safer to keep you images in a folder within your FileMaker solution, so it gets moved when the solution is moved someplace else:

"image:" & "images/" & filename &".jpg"

you can determine the path to a specific image by placing a file in a container field by reference, then place it on a layout as placeholder: it will show the filepath.

<<image>> -->

image:../images/sample.jpg

imagemac:Macintosh HD:Users:username:Desktop:images:sample.jpg

imagewin ...

or simply use a textcalc:

path=image, evaluate as text.