I’m trying to set up a view that shows all the details from a parent record to its grandchild records. Can this be accomplished using the “Connected Tables” feature?
Are you looking to view the data in a detail component or a table/list component?
In a Table Component
When you add a table component to a detail page, you should see options for related records. This is typically representative of grandchild/grandparent records.
Thank you, I will review
To clarify, I am looking to see it in a Table/list component, like The picture I attached, a view that I can display all of the data starting from parent down to the grandchild.
The attached article is perfect for viewing a single record not a all view
Ah I see, thanks. The components we have such as the table component can only display data from a single data table + any fields from a directly connected record.
@Motty -
This may be able to be accomplished as @tim.young stated by using rollup fields. You would have to provide a connection field FROM all the children/grandchildren/great grandchildren tables TO the parent table. Then add rollup fields in your parent table by selecting the appropriate table and then “Concatenate” option.
I haven’t tried it but worth a shot. Are you familiar with the rollup fields and such? If not, we can jump on a virtual call and I’m happy to explore with you.
Adam