Unique Groups of Records
Hi, I have application where I need to add "preps" via a child table portal for the parent table records. The preps consist of 5 fields and typically each parent record will have 3 to 5 prep records (children) but theoretically could have any amout. Parent record B may or may not have the same preps as record A and so on. However it is common that several parent records will have the same "group" of preps
I'm trying to find a way to identify parents that have identical groups of prep records so that I can later consolidate the parents in a detailed sub-summary report. Any ideas?