>I'm designing a report that involves a one-to-many relationship. It prints out the contents of my check register. Some checks have more than one expense category (the many part of the relationship).
>When I run the report, only the first record of the child table prints. What am I doing wrong.
You need to drive the report off the child records rather than the parent; you group by the parent key.
Even better, cureate a cursor thatcombines the child records with their parent record fields, and just run the report against that cursor, eliminating the worry about who drives what.