>>I basically want to scan 3000+ records
>>
>>scan
>> n = recno()
>> copy to array temp for
>> select
>> go n
>>endscan
>>
>>copy fields from array to another database
>>
>>print the report
>
>I really don't understand why you are scanning to get the same results to a secondary table.
>
>If all you want is to print the report based on a subset of data, you may do just that in 2 lines: SELECT SQL ... INTO TABLE TEMP + print the report.


The problem is I have to pull out the records to another table only if it meet the condition in the (copy to array temp for )
and produce a report which have all the candidates informations which meet that special condition.