>If you have a parent table with many child tables (say 6) how do you print the parent record
>first then all the records related to the parent table in the first child table, then the next child
>table etc. Since the Report Designer does not support subreports how can this be done?
>
>Any suggestions will be greatly appreciated

build a cursor using sql statement containing parent w/ all children. run the report from that.