I have been struggling with a Window Refresh problem - have found a solution but do not understand why the problem occurs.

I have a script which adds new records (in a new window) and then returns to the original window with a portal containing those records. The new window is closed after adding the records. The portal uses conditional highlighting to show the record just added and has a GoToField step to open a related record on the same layout, ready for editing.

The script looks like:

New Window [ Name: "Updates"]

Go To Layout [ "Updates (Updates) ]

{Various Set Field steps follow}

Select Window [ Name: "Home" ]

Refresh Window [Flush Cached Join Results ]

Go to Field [ Current Update::Update Text]

Close Window [ Name: "Updates" ]

This results in Error 101 - Record is Missing on the Go To Field step and the portal not correctly Refreshed.

But closing the second window first as in:

New Window [ Name: "Updates"]

Go To Layout [ "Updates (Updates) ]

{Various Set Field steps follow}

Close Window [ Name: "Updates" ]

Select Window [ Name: "Home" ]

Refresh Window [Flush Cached Join Results ]

Go to Field [ Current Update::Update Text]

Results in the script correctly Refreshing the portal and going to the correct field.

Surely the Refresh Window step should work in either case as the Active Window has already been specified by the Select Window step.

Grateful if anyone can explain the logic to me as it makes little sense to me.

Jim

In the first script, does the new record get committed before switching back to the first window?

That fixes it - many thanks.