I need to know how to list all the possible subsets in detail section 2 that match the fields in detail section 1.
Detail section 1:
Field1: Blue Field2: Red
Field3: Oak Field4: Door
Detail section 2:
Field 5 Field 6 Field 7 Field 8
If I have multiple records that have the same same values for Field1, Field 2, Field 3, Field 4, I want each of them to show in detail section 2. However, currently Detail section 1 is being repeated for each record.
What do I need to do to in order to only have the one detail section1 displayed with all the matching records printing in Detail section 2?