kluong

Thanks for both solutions and I will give them a go to see if the problem can be resolved. Really appreciate any help from your guys.

Hi everybody, I am new to Filemaker and currently struggling to set up a calculation field to display photo based on the photo link from another field. The database I am working on containing over 100,000 jpegs and each record has a photo as proof of service. Manually importing those photos would take several month to complete. I have 2 photo fields: Field A contain the link or path to the location of a photo stored on my hard disk. This information is imported from Excel data spreadsheet. Field B is set to display the photo according to the link from field A. Example from the field A :C:photosMay2010IMG_2121.jpg Working out the calculation for field B to display the photo from field A is beyond my current ability. I hope some experts in this forum can help me to work out the needed calculation for field B so all photos can be displayed once the data from field A are imported. I am using FM Pro Advanced 11 on Win XP. Thanks in advance