Linking multiple tables in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Am stuck up! Have 1 table which has one to many relationship with other 3
tables.
I need to prepare report which links all the 4. Example : Ist table has
trans no which is unique.. other three tables has trans no which are linked
to Ist table and can repeat. I need report which gives all transactions from
4 tables but when I prepare report thru query, the transactions in Ist table
repeats when there are duplicate transno in related tables. Pls advice
 
You have one main table, and 3 related tables. Use subreports for the other
2 related tables.

Create a query using the main table and ONE of the other 3 - any one,
whichever one makes sense to you.

Creat the report based on this query. In report design view, open the
Sorting And Grouping dialog (View menu), and select the main table's primary
key. In the lower pane of the dialog, set Yes for Group Header and for Group
Footer. In the group header, place the items that should appear once only.
In the group footer, create any summary you want from the related table you
chose, e.g. =Sum([Amount])

Then use 2 subreports to show the information from the other tables.

Sometimes it helps to create more than one group footer on the main table's
primary key more than once (i.e. select the same field in multiple rows in
Sorting And Grouping). You can then put the subreports into sections of
their own. The page breaks work out better with some layouts if you do this.
 
Without a better understanding of your tables, consider using subreports for
some or all of your related tables. You can use the Link Master/Child
properties just like you would for subforms on a main form.
 
Back
Top