SELECT Parent.*, Child.* ; FROM Parent, Child ; INTO CURSOR MyCursor ; WHERE Parent.Key = Child.Key ; ORDER BY MyParentField1, MyParentField2, MyChildFieldand now you want the report grouped on MyParentField1 and MyParentField2, with the data from the child fields in the detail line of the report. The cursor must be ordered (or indexed) on the MyParentField1 and MyParentField2 (for the grouping) and MyChildField (so that the child records will print in whatever order you like.)