@Kolbi_Christianson and @Steve_Yang, hey appreciate the commentary here!
Kolbi, I think what you are describing is what I’ve been doing on my own as what I’d call a “manual” process that requires a good deal of delving into formulas, in particular filters and “thisrow” which has been one of the more challenging for me - I am not a developer. And in fact, Steve has hit the nail on the head of the point I was trying to make: Coda has the architecture to handle fully infinite “children” within a row due to the ability to do lookups inside a row and table. However, it is not intuitive from a UX point-of-view I’ve found, exactly as Steve is suggesting.
The other point that I continue to struggle with is the distinction between Lookups from other tables, and Lookups from the same table. There is various behavior I’ve seen - sorry I can’t recall now as it’s been a while since I looked at this closely - where they are different. Things like grouping and the ability to add inline, and some others I think.
I am really hoping to see some improvements come down the pike soon, I’m guessing the Coda Product Team has this somewhere in the backlog based on @Krunal_Sheth comment here:
which is a great post exhibiting the power of Coda, but again, too advanced for me!
Thanks again for your responses!