I would like to insert a picture for each product record in my database in a certain way and thought I had sorted it out - but I haven't.

I have a folder on my server that contains product images and I have a container field in my database ready to hold these pictures.

The name of the image matches the product code of the related item.

What I am trying to achieve is to have a button trigger a script that will insert the right image into the container field for that product.

With that in mind, I have created a calc field called 'path' which looks like this:

"imagewin://SERVER/Images for FM Server/Lo_res/" & Product file::Item code & ".jpg"

I then have created a script which is below:

Set Variable [$filepath;Value:Product file:path]

Insert Picture [Reference;"$filepath"}

I was sure this script would work , but it hasn't

can anyone tell me where i am going wrong.

thanks

I see where I went wrong.

I must use a 'goto field' before the insertion of the picture otherwise it doesn't know where to insert it!

stupid me.