Creating a report where some records have multiple subrecords

[halt4814]

I have two tables, one [NAME] containing ID numbers with persons names, and another [ORDER] containing ID numbers and orders placed. I am trying to create a report that has the ID number and persons name in the report header then in the detail section it lists all the order that that particular person placed.

When I did this, it just repeated the entire header and detail for as many order's placed there were.

For example, it showed



ID: 23
Name: MDH

Order Quantity
12 2
13 5
32 1
-----------------
ID: 23
Name: MDH

Order Quantity
12 2
13 5
32 1
-----------------
ID: 23
Name: MDH

Order Quantity
12 2
13 5
32 1



The report just repeats the data three times. How can I make it so it only displays each ID record once with it's appropriate subrecords below it?

[June7]

Use report Grouping & Sorting functionality. Create a group on the ID field, put textboxes for ID and Name in the group header, other data in detail section.

Or

Textboxes on report have a HideDuplicates property.

[halt4814]

Worked! Thanks!