GTRR How it works
I have tables PayrollBatch and PayrollCheck. They are related through the PayEndingDate field.
I have three records in PayrollBatch and four records in PayrollCheck.
I have GTRR set to go to ALL RELATED RECORDS.
What I am getting is that all PayrollCheck records are in the found set. But when I select GTRR I go to the right record in PayrollCheck. But they are all there. Should it be a found set of JUST THOSE RECORDS or do I need to script the find to the related records so only those meeting the primary-key (PayEndingDate)?