AnsweredAssumed Answered

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

Question asked by edyas on May 15, 2016
Latest reply on May 22, 2016 by beverly

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)

Outcomes