if you are populating a global field with a list of record ID's, you can create a self-join between the global field and the ID field. Using the "go to related records" script step based on this new relationship will reduce the found set to just those in the list.
You can do a script that loops through the array of ID's in the global field to find each one. Something like:
set variable [ $IDs = GlobalTable::GlobalField ]
Go to Layout [ whatever layout ]
Enter Find Mode
set variable [ i = 0 ]
set variable [ n = ValueCount ( $IDs ) ]
set variable [ i = i + 1 ]
Exit Loop If [ i > n ]
set variable [ $ID = GetValue ( $IDs ; $i ) ]
set field [ TableName::ID = $ID ]
New Record Request
Delete Record Request [ No ]
set error capture [ on ]
set error capture [ off ]
David Moyer wrote:
Using the "go to related records" script step based on this new relationship will reduce the found set to just those in the list.
If you check that option.
(I gave the fish, just didn't cook it)