>
>Lincoln, if you are using a cursor for the child records (as in my other reply) check that you have them listed in the ORDER BY clause. If you're using linked tables then you'll have to do it with the indexes on the linking fields.
>
>Barbara

I'm getting lost. Let me try to explain more specifically. I have parent table "Names" and three child tables: "Scars," "Marks," & "Tattoos." I'm trying to create a report that will run from my intake form with the click of a button. The report displays the name, address, etc. of personal data and any scars, marks or tattoos of the individual. Most of the information is located in the "Group Header1 name_id" band of the report designer, since most of the information has only a single entry for each name (only one DOB, Marital-status, race, etc.). However, a person can have more than one scar, tattoo, etc. Therefore I have placed the scars information (a "Scars:" label and two fields:"scars_loc," and "scars_desc") in the "Group Header2 scars_id" band and the tattoo information in "Group Header4 tattoo_id" band, etc. The fields of each are encased in a rectangle and are both stretchable and grouped. The labels are set to only repeat if a new page is generated. I want the effect to be:

SCARS: Left Cheek -- 2" crescent shaped scar.
Right Wrist -- 1 1/2'" scar across wrist.
Abdoman -- 3" apendectomy scar.
MARKS: Neck -- 2" circular birthmark on right side of neck.
TATTOOS: Left Forearm -- "Mother"
Left Bicep -- "Rosie"

But what I'm getting is:

SCARS: Left Cheek -- 2" crescent shaped scar.
MARKS: Neck -- 2" circular birthmark on right side of neck.
TATTOOS: Left Forearm -- "Mother"
Right Wrist -- 1 1/2'" scar across wrist.
Left Bicep -- "Rosie"
Abdoman -- 3" apendectomy scar.

I don't understand what you mean by indexes on linking fields. I am using linked tables. I have one-to-many selected in the Relationship DE. I have the groups set using the primary_keys of each table. I have tried setting the groups using a different field (the linked "name_id" fields) but this only produces one entry for each field (the first one).

Is what I'm trying to do not possible? Surely this has to be a common requirement.

Thanks for your help & your patience.
--lincoln