I have one to many relationship tables.At the table level the relationship is clearly represented by the main table (on the 'one'side') and the subdatasheet for the 'many' side(second table).These tables are being front-ended by a mainform(on the 'one' side) and a subform(on the 'many' side).My reports are based on underlying queries.My concern here is on how to represent this data relationships on the reports???? with subtotals and grand totals.????I have tried to put a subreport at a details section of
the main report but there was some data duplicates....the same applies when I ran the query itself....is there any suggestions???Below is the sample illustration:
Here Main Table One(on the one side)relates to Table Many(on the many side)
Table One Table Many
Record A A1,A2,A3,A4
Record B B1,B2,B3,B4
The Detail report should display
Record A
` A1
A2
A3
A4
subtotalsA
Record B
B1
B2
B3
B4
subtotalsB
Grand totals:Record A + Record B + subtotalsA + subtotalsB
Could this be represented in summary form also????
IS there any way to improve the above representation????
Any suggetion is highly welcome and appreciated!!
Thanks