Walter. If you are setting setting relations in the dataenvironment of the report, I have found problems with this method. Instead use SELECT to combine all of the data into one cursor and use this for the report.

>i have a BIG problem within a Report.
>There are three tables, called „office“, „members“, „Jobs“!
>It should look like follows:
>***********************
>Office xy
> Member Dagobert
> Job Stuntman
> Job Salesman
> Job Looser
> Member Kermit
> Job Nothing
>Office zx
> Member Donald
> Job Executive
> Job else
>Sum: all Offices, all Members, all Jobs
>***********************
>OK:
>It works fine, but the table „Jobs“ brings only the first record of this member.
>Will be:
>***---------------------
>Office xy
> Member Dagobert
> Job Stuntman
> Member Kermit
> Job Nothing
>Office zx
> Member Donald
> Job Executive
>Sum: all Offices, all Members, all Jobs
>*****--------------------
>The oneToMany-Relations are true, but the Report takes no care.
>
>What is to do, if there are more then two relations ? (office to member works fine)
>
>Some ideas, any suggestions are very welcom
>
>Walter