Re: ACE Report Question

Thanks for the responses, but I guess I forgot to add the Phone Number to the output. What if the output looks like this: Name: Bob ID #: 111111 Books: 1, 2, 3 Phone: 555-1212 Name: John ID #: 222222 Books: 5 Phone: 333-1212 Name: Jack ID #: 333333 Books: 4, 6 Phone: 111-1212 This is a little more complicated... Thanks again, Chris Hushour : 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 -- ------------------------------------------------------------------------------ Chris Hushour Internet: cwh@evolving.com Evolving Systems Incorporated Englewood, Colorado