Hi everybody, I am new to Filemaker and currently struggling to set up a calculation field to display photo based on the path from another field (imported from Excel). Example from the PATH field :C:\photos\May2010\IMG_2121.jpg - I'd like to have this photo displayed on another field but could not figure out the proper calculation for that field. Please help. I am using FM Pro 11 on Win XP. Thanks in advance.
Yes, I guess my answer wasn't very sufficient. Sorry about that.
Your calc field should be set for container results, and the calc would be:
"image:" & pathField
PathField should look like the following
To accommodate your current path contents into the calc field, you can use something like:
"image:/" & Substitute(text1; "\\"; "/")