ACE Report Question

I'm attempting to write an ACE report that uses multiple tables. Each page of the report contains 1 row from each of the tables except for one of the tables which contains multiple rows. I will visualize: Table 1: ID# | Name | Phone | ------+------+----------+ 111111| Bob | 555-1212 | 222222| John | 333-1212 | 333333| Jack | 111-1212 | Table 2: ID# | Book # | ------+--------+ 111111| 1 | 111111| 2 | 111111| 3 | 222222| 5 | 333333| 4 | 333333| 6 | The report I want to generate will look something like this: Name: Bob ID #: 111111 Books: 1, 2, 3 Name: John ID #: 222222 Books: 5 Name: Jack ID #: 333333 Books: 4, 6 Any thoughts or suggestions? Thanks, Chris Hushour -- ------------------------------------------------------------------------------ Chris Hushour Internet: cwh@evolving.com Evolving Systems Incorporated Englewood, Colorado