Problems looping through found set

[iandmcneill]

Hi,

I have a simple task for a script but cannot get it to work..

The script should loop through the found set of a table, perform a find on another table depending on the current record in the first found set.

Basically the script logic is (after initial find)

loop

set global field to current value of a field in the found set

perform a find on another table using that global field as criteria

should the found set

go to the next record in the first found set

end loop

Should this be as easy as I think?

Thanks in advance.

[kevh72]

Assuming you are performing the search in the second table in a different layout, you have to return to the original layout before going to the next record in your first found set.

[iandmcneill]

Hi Thanks,

I was doing that - it seems that entering preview mode was setting the cursor back to the start of the result set of the first find.

Ta,

Ian