Stepping through a found set to duplicate records
I wish to duplicate selected records (within a found set), then change the field with the match criteria. My problem is that the found set grows each time I duplicate, even though the new record no longer matches the found set, so the next record is always the first created:
Enter Find Mode
Set Field [Table::Source_Job_SN; $SourceJobSN]
Set Variable [$Steps ; Value; Get(FoundCount)
Exit Loop If [$Steps <1]
Duplicate Record / Request
Set Field [Table::Source_Job_SN; $NewJobSN]
Commit Records / Request [No dialog]
Go To Record / Request / Page [Next]
Set Variable [$Steps ; Value; $Steps -1)
I suspect I'm not using the found set correctly.
PS I just noticed "Exit after Last" which looks like it will save manual counting.