FM6/Win32: Images in calculated container fields

[nedwilson]

All,

I am making some modifications to an existing database to display images along with database records. There are thousands of images available, so individually dragging and dropping them is not an option. The filemaker database is running on my local machine, and the images are on a network server, located in folders that are keyed by an ID, which I have in the database.

For instance, if i have a field "ID" in the database, I can be guaranteed that a network share "Z:" will have a folder with the same number as the ID, but the image may not be available. If i wanted to look at this image in windows explorer, I would view "Z:100-222picture.jpg".

So, I am trying to display these in FileMaker. I have created a Calculated container field, using the following syntax for the calculation:

"image://z:/" & ID & "/picture.jpg"

Nothing is being displayed in the container, but I have verified that I am on the right record, and I know that the file exists and is readable on the network share.

I have a suspicion that the syntax i'm using for "image:" is incorrect, yet I am unable to locate any documentation on exactly how to word this.

Help!

-ned

[nedwilson]

All,

Does anyone out there have any suggestions? I found out that FileMaker 6 does not support the "image://" syntax, so I tried building the calculation with "file://" instead.

Is there anyone out there who can help?

-ned

[nedwilson]

Just got off the phone with FileMaker tech support - they said that this can't be done in version 6. Bummer! They suggested that I upgrade to 7.