Create a script to change a picture reference

[jimkent]

I have a picture database of almost 10000 pictures. It is located on a Raid Drive on my Mac a few folders deep. Within that folder, I have other folders that have the the jpg files of these 10000. My Database uses a container file and stores a reference to these jpgs.

The problem I have is if I move the database file to some other folder or drive that is not the same name as I started, the references to all those pictures (or the container field) will be blank (cannot find imagexxxx.jpg) will be posted in the container field.

Is there anyway I can write a script that will relink those references to a new folder or folder(s)? There has got to be a way to see the path to the reference isn't there?

[comment]

You can set the field to a new path, using a text calculation to replace the folder part. Have a look at what GetAtText ( YourContainer ) returns to see the current path.