This problem seems to be easy to solve but somehow it has driven me mad in the last few days.

This database has hundred thousands of records, each has a photo section with 2 fields: field A contains the link to photo (imported from Excel) and field B is a calculation field with result as a Container (to display image from field A). The calculation is: "imagewin::" & Substitute (PHOTOLINK ; "" ; "" )

where PHOTOLINK is the field name of field A.

The result is a message "the file cannot be found: C:\Photos\IMG_2222.JPG"

I've checked the photos and their preferences and found no mistakes. I've tried every possible solutions but stil can not have the images displayed.

I would be great if someone can figure what is wrong with me or my calculation. Thanks.

FM11 Pro Advanced - Win7

The calculation is: "imagewin::/" & Substitute (PHOTOLINK ; "" ; "" )

Not sure what this does. Try a calculation that will return:

imagewin:/C:/Photos/IMG_2222.JPG

Not sure what this does. Try a calculation that will return:

imagewin:/C:/Photos/IMG_2222.JPG

I tried that and it still did not work; for some reasons, FM can not find any files in any hard drives of my computer however, there is no problem with direct inserting the images.

I suggest you do the following experiment:

Create a new file with 2 fields: a container field, and a calculation field (result is Text) =

GetAsText ( YourContainerField )

Insert a picture into the container field, as reference only. The calculation field should now show three lines, something like:

size:480,320

image:../Photos/IMG_2222.JPG

imagewin:/C:/Photos/IMG_2222.JPG

Compare the third line with the result of your calculation - they need to be exactly the same.

Thanks for the solution, I'll give it a try.