AnsweredAssumed Answered

Unique Groups of Records

Question asked by brodlang on Apr 1, 2013
Latest reply on Apr 2, 2013 by philmodjunk


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?