Quiz quandry

[Mike Palandri]

Hi all,

I'm trying to write a report that does not fit into the 
Quiz processing model.  

There are two files with the same keyfield, each with one  
or more records per key value, so for any key value, 
file A could have more records than file B, or vice versa, 
e.g.:

File A:

Key Data
1   aa
1   bb
2   aa
3   aa
3   bb
3   cc
3   dd
4   aa
5   aa
5   bb

File B:

Key Data
1   xx
2   xx
2   yy
3   xx
3   yy
5   xx
5   yy
5   zz


I'd like to report the key and data from each file side by 
side like this (this will look goofy in a proportional font):

     File A   File B
Key  Data     Data
1    aa       xx
     bb

2    aa       xx
              yy

3    aa       xx
     bb       yy
     cc
     dd

4    aa

5    aa       xx
     bb       yy
              zz


If I link on the key field I get a record complex that
contains a number of records that is a multiple if the
records for key values in File A and File B, e.g. for a
key value of "3" the record complex looks like this:


     File A   File B
Key  Data     Data
3    aa       xx
3    aa       yy
3    bb       xx
3    bb       yy
3    cc       xx
3    cc       yy
3    dd       xx
3    dd       yy


In the past I've sorted by either file A data or File B 
data and reported the detail as a "foot at", but as you
can see, that won't work here.

Has anyone had experience with this type of reporting?

Thanks,



Mike