>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,