Count(related::field) will work on several relationships away.
Count (parent) = all records in parent
Count (children) = all records related to parent
Count (grandchildren = all records related to grandchild through the child relationship.
Do you want to "add" all the grandchildren together for all the found parents? or ??
1 of 1 people found this helpful
What Beverly suggested will work, but only one a per-record basis, not for an entire found set.
• create a summary field ListOf
• create an unstored calculation field, type text, that simply references this summary field
• use this to create a new relationship
Parent::cListOfIDs = Child_toCount::parentFK, and add
Child_toCount::childPK = GrandChild_toCount::childFK
Now Count ( Child_toCount::childPK ), and Count ( GrandChild_toCount::grandChildPK )
Alternatively: create a script that hops to Child via Go to Related Record ( Child ; matching only ; match found set ; new window ), gets the found set and writes it somewhere (global $$var), then goes to the related set of GrandChild (without new window…), then closes the window.
Many thanks, beverly and erolst!
Yes, I am indeed looking for a solution encompassing the entire found set.
I will now try implement the approach suggested by erolst.
Many thanks again,
The Summary field (Count) will work in a list view, summary part sorted by the fields that need to "trigger" the count!.
NOTE: this is different from the calculated function Count().