Update broken links to image

:) I know it's Friday and you want to go home:

I'm new to this Forum, but have used FM a little in the past. I have three problems I am try to solve:

1. I designed FM on my pc linking image containers using a text field, then added a calculation to link the path using;

"imagewin:/"& $$id &"/"& Image_ID &".jpg". (image_Id is the text field).

I also set up a global script path for each $$ folder 'id', 'logo', etc. Finished the beta version which works fine when I import new records, add or amend an exiting record. I have also used to same technique to report the 'image' file name when inserted through the container.

I then moved the root folder to another pc and a 'temporary image report field' confirms 'image' shows the old path and will only update if I edit Image_Id text field.

Is there an easy solution to write a script to fire and one-off update for all image paths? I tried 'update link', but couldn't get it to work. Also can you set a script to fire when a file is opened, (set global folder path)?

2. Would love to offer a traffic light symbol (red /green symbol)or change the 'fill' colour to 'red' or flashing red when the date value 'validuntil' < 'current date'; Any ideas?

3. I have a field called 'Authorizing Offier', which contained a name that needs updated on all records when that person leaves. A Gobal value is fine, but I need to be able to switch it on or off; that is set how the value is changed; on edit, on renewal, on demand; any ideas?

regards