>>
>>I've often found a scan to be faster in VFP for this.
>>I would do it this way, however:

use table2
>>use table1 order propid in 0
>>set relation to propid into table1
>>scan for eof("table1")
>>  ** do code
>>endscan

>
>Trey,
>
>Are you sure, your code would find records from Table1, which don't have corresponding records in Table2? You're scanning Table2, so I assume, your code would find opposite.

Sorry - I was using table1 as parent and table2 as child - you confused me going the other way <g> here it is clearer

use child
use parent order propid in 0
set relation to propid into parent
scan for eof("parent")
  ** do code
endscan