Hi there,
I need help before i quit my job or shoot myself.

Anyway, i need to display some information on a report but its not working out correctly.

I have 2 tables imported to my report.
the 1 st table lists organization (org)  and order (ord)

so its in the format of

Table 1
org1     ord1
org1     ord2
org2     ord1
org2     ord2
org2     ord3

so i display this information in the report and supress the duplicate org's
so in the report it displays correctly.
eg.

org1
  ord1
  ord2

org2
  ord1
  ord2
  ord3

so far im good. here comes the hard part. on the next table, i have 'people' which has a primary key link with the 1st table (org)
so the structure of table 2 is

org1   ppl1
org1   ppl2
org1   ppl3
org2   ppl1
org2   ppl2

so the number of records in these 2 tables may not be the same as you can see.

the issue now is that i want to display a report like this

org1
   ord1
   ord2
   ppl1
   ppl2
   ppl3

org2
   ord1
   ord2
   ord3
   ppl1
   ppl2

but its being displayed like this instead


org1
  ord1
    ppl1
    ppl2
    ppl3
  ord2
    ppl1
    ppl2
    ppl3

org2
   ord1
    ppl1
    ppl2
   ord2
    ppl1
    ppl2
   ord3
    ppl1
    ppl2

the report has 2 sections and is formated as below

section a
org
ord

section b
ppl


help!!!