>>>scan for filename.fil_total = filename.fil_subtot
>>SET ORDER TO TAG fil_total
>>SEEK FileName.fil_subtot
>>SCAN WHILE Fil_Total = FileName.Fil_SubTot
>
>
>I don't think that'd work since he wants to scan the table for records that have matching fields (fil_total and fil_subtot)
>
>it'd be like saying:
>select filename
>seek fil_subtot && 1st record would match! and so stop would happen
>scan while ... && You'd not get all records that match; just the 1st record & any recods after that until they no longer matched... skipping the rest of the table...

In that case, you're right...but that's not what his code showed.