Julius,
The easiest way to solve this is to use SQL-Select to put the data you want into a cursor. You can develop a non-normalized cursor that has both parent and child table data in each record and order it as you want. Then you don't need to worry about linking tables.

HTH
Barbara

>Hi! I have a problem with the report writer of FPW2.6. I have two databases with relations set. Concretely;>
>

  GL1.dbf               &   GL2.DBF
>    acct_code <---------------> acct_code
>    Title                       Fullname
>    Debit                       Debit
>    Credit                      Credit
>
>I wanted the report to look like this;
>
>   Voucher Print-out
>
>    Title                                        Debit      Credit
>    ------------------------------------------- ---------- -----------
>    Petty Cash                                      100.00        0.00
>    Accounts Receivable                                         100.00
>       + Sotomil, Julius P.       0.00    50.00
>       + Sotomil, Joey P.         0.00    50.00
>                               -------  -------
>                                         100.00
>

Now, I can't seem to display all of the related records from the second database. I only get Sotomil, Julius when I run the report. Even with the DATA Grouping thing of the report pointing to the second database set to acct_Code.
>
>
>Please help... :(
>
>Julius