I am having difficulty in producing a report and would be grateful for
some help.
The database consists of 2 panels:
1. Panel 1: an incrementing key field, name of composer, name of piece,
catalogue number
2. Panel 2: is linked to Panel 1 by the key field, details for a
particular name of piece.
To give an example:
In Panel 1:
Key field, composer, name of piece, catalogue number
1, Alkan, Etude, cda67654
2, Alkan, Piano Sonata, cda67654
In Panel 2
For record 1 in Panel 2 there would be no records, but for record 2 from
Panel 1 there would
be several records, eg
key field, details
2, 1st movement
2, 2nd movement
2, 3rd movement
What I am struggling is in produced a report formatted to text which is
formatted as follows:
composer (from panel 1), name of piece (from panel 1), details (from
panel 2).
The problem is that the name of piece field for some records only need
to be appear once (if
there are no linked records from panel 2), but in some cases needs to be
repeated several times
if there are several linked records in panel 2 (that is if I am trying
to produce the report
starting from the panel 1), but if I am producing the report from panel
2, the problem is that
because some records do not have related records in panel 2, then they
would appear in a
report started from panel 2.
To develop the example given above, the final report I wish to create:
Alkan, Etude,,
Alkan, Piano Sonata, 1st movement
Alkan, Piano Sonata, 2nd movement
Alkan, Piano Sonata, 3rd movement
Help with this would be greatly appreciated.
Victor Warner.
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
