Hi,

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