We just upgraded to FileMaker 13 and Filemaker 13 Server running on a server with Windows 12 server OS

 

Our database contains inventory of some 200 thousand Items, each Item has a photo associated with it. The Photos are located in a folder on the server.

 

Is there a way I can relate the Item# and the Photo saved as the same name as the Item# that is located in a File Folder.

 

Item# = 12345

Photo = 12345.jpg (the Folder name is MASTERIMAGE)

 

I tried this   "imagewin:/c://‪MASTERIMAGE/Item#"&".jpg"

but it won't work

 

 

Can anyone help?

 

 

- Design a Calculation Text field: Photo_Path containing for example: "file:///" &"ServerMASTERIMAGE" & database::Item# & ".jpg"

- Add a web viewer on your layout with the following web address: database::Photo_Path.

 

Comment: You don't absolutely need the calculation field (I just prefer), you can write the calculation is the web viewer setup and be done with it.