Hi there. I am developing a database for a picture framing company to hold details of thousands of images that they have. I have jpeg images of all of these and the path to the jpeg is held as a field in the table. I have a 'Container' field called 'Picture' and should like to populate this field by a script on one pass through the table. If anyone can help me I should be obliged.

Merry Christmas and a great New Year to you all.

Graham

The container field needs to actually hold the path to the referenced image. If your images are named, let's say for the record number of the image, then you can calc this path.

However, thousands of images suggests that 360works' SuperContainer might be something to look at.

Hi there

Happy New Year.

I'm sorry but I still can't see how this works. The container contains the full path to the image but only shows as text e.g. "c:/image library/image/picasso drawings/pd1.jpg", I am a loss as to how to turn that into the actual image. Cost restraints will not allow me to go the 360Works route.

Regards

Graham

This is not a filemaker path:

c:/image library/image/picasso drawings/pd1.jpg

that is an OS path.

Thanks so much, that cured it. Realise just how much I have to learn.

Best regards

Graham