4 Replies Latest reply on May 22, 2016 8:44 AM by beverly

    Count [all Children] and [all Grandchildren] of [all Parents]

    edyas

      Hi,

       

      I have defined one-to-many relationships between 3 occurrences: [Parents] - [Children] - [Grandchildren].

       

      I perform complex searches in the context of [Parents].

      Whenever I've performed such searches, I would love to display three different figures in [Parents]:

      - the count of all records found in [Parents],

      - the count of all [Children] related to all records found in [Parents],

      - the count of all [Grandchildren] related to all records found in [Parents].

       

      Just to be clear, I am not trying to display the number of [Children] and [Grandchildren] for each and every record in [Parents], but well the total number for all records found in [Parents].

       

      Is there a way to do that? I would be very grateful for any help.

       

      (I would love to do the same in [Children] and [Grandchildren], but I figure I will be able to replicate the solution to those contexts)