Sorry - should have mentioned I am using FM Pro 14.
Once you have your data and it's sorted, call a script having these lines
Set Error Capture [ On ]
Go to Record/Request/Page [ No dialog ; 11 ]
Omit Multiple Records [ No dialog ; 1000000 ]
That was easy. Thank you!
I understand what the go to record line is doing. What is the omit multiple record line actually doing?
the omit multiple records takes out records from the found set, starting with the record you're on. So if you have 10 records and sitting on the first, omit multiple records(3) will reduce your found set to 7, eliminating the first 3 records from it.
Now, some nitpicker around here might raise the hand and say "why omit 1 milion records, when you can be more precise and Omit Multiple Records [ No dialog ; Get(FoundCount) - Get(RecordNumber) + 1 ] " ?
To which I answer that instead of spending CPU cycles calculating the correct hammer to use with that nail, I just hit the bastard with an anvil, because I can.
Sounds like solid logic to me - and it works! You've saved me some serious time. Thank you very much! -Tom