I prefer to get all of my data into one cursor before running a report against it. Otherwise report preview printing can be flakey. An example of what you could do is...

SELECT dgl1.*, dgl2.fullname ;
  FROM dgl1, dgl2 ;
  WHERE dgl1.acct_code = dgl2.acct_code
  INTO CURSOR cReport

REPORT FORM rJulius TO PRINTER PROMPT  

I am confused by credit and debit appearing in both tables.

>Is there a way for me to be able to use two database
>in a report? One with relations set.
>
> DGL1.dbf & DGL2.dbf
> Acct_code <-----------> Acct_code
> Title Fullname
> Debit Debit
> Credit Credit
>
>
>Thanks,
>
>Julius