master table for many details tables

[abdhab]

Hi
I have a master table (M) and many details tables (D1, D2, D3)
the relations i have between all the tables:
1 to n between M and D1
1 to n between M and D2
1 to n between M and D3
all the details tables have the same foreign key (which is the primary key of the master table)
i am trying to find a report that displays all the data for a specific record in M and all its related data from the details tables..
the problem here, is that the data are repeated a lot in the report (cos of the join)
any idea how to solve this problem?
thank you

 

[PaulBricker]

I would suggest using subreports. Add one for each detail table and link the Child in each detail table to the Master. That should do what you need.

Paul

 

[abdhab]

thanks
but i just figured out how to do it..
i used "UNION ALL", it is good..

 

[PaulBricker]

Glad you got it working.

Paul