Updating my request - I wish there were a way to edit the main post :).
I think part of my problem may be rooted in the fact that I have actually a GREAT-Grandparent here. I simplified what was written above, and am now exploring this a little more. Here's what I have, and ultimately, I want to pull the Grandchild to the Grandparent
GGP: Community Organizations
* GP: Emergency Departments
C: Contact
* GC: Activity
I don't have a relationship built as I thought I had, between GP and GC. I have the relationship between GGP and GC.
Going to work on this and see if what i need to do is build a summary field. But ultimately I'd like the grandchild records to roll up tot he Grandparent, and display on the form (I did achieve this ages ago through whatever workaround I made), and also, eliminate the end user's need to manually enter in the GP. Ideally, they should look up the Parent contact, and be done.
