Julie, I also find it a little confusing that you tried to set a relation, and then in the REPORT command you did a

FOR ... AND product.compyID= company.compyID

I would think that this would only print records where product.compyID is equal to the current company.compyID...in other words, the report will depend on where the record pointer is in the company table.

>>SELECT company
>>SET RELATION OFF INTO product SET ORDER TO 1 SELECT product
>>SET RELATION TO product.compyID = Company.compyID INTO company;
>> ADDITIVE
>>REPORT FORMAT ProductList.frx FOR product.code = ;
>>SUBSTR(ALLTRIM (prod),1,4) AND product.compyID= company.compyID ;
>>ENVIRONMENT TO ;PRINTER NOCONSOLE
>>
>>Table names are Company and Product
>>Prod is the field name for the product code on the report.
>>----------------------------------------------------------------------
>>The above code prints out a blank page.
>>
>>Any suggestion?
>>
>>Thanks!
>
>Yes, SET RELATION TO table1.field1 = table2.field2 INTO table2 is wrong.
>
>If the link between table1 and table2 is field1 and field2, you need:
>SET ORDER TO field2 && IN table2 (if not curr. work-area)
>SELECT table1
>SET RELATION TO field1 INTO table2
>
>This assumes there's a tag in table2 named field2.
>
>HTH,