I have a DB script that is doing some data manipulation. In my script, the db leaves the current layout to do some manipulation in another table. It's triggered by the value that is in a field of the original layout. When it comes back to the original layout, I would like the script to start at the field that it left off at.

I am having trouble geting the script to go to the next field. When I come back to the layout, it starts at the first field. I tried putting in a temp Global variable but the Goto Field step does not allow for variables. Any help would be appriciated.

Thanks.

Hello Jim,

Up to and including version 7.0v3, there is no direct programatic method for dynamically selecting or setting a field. So you'll have to build your own method.

For example a scripted sequence along the lines of the following may be worth considering:

Loop

Go to Next Field

Exit Loop If ["Status(CurrentFieldName) = gTempText"]

End Loop

...where gTempText is a global text field into which your scripts have previously stored the name of the field to which you wish the script to return.