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
Greetings from Germany