How to get certain grandchild rows

[NCD]

what would be the expression to bring all the instructions of a related recipe of that product?

[Suvrutt_Gurjar · Accepted solution]

Please try below

1. You will have a column in the "Products" table called something like [Related Recipes]

2.  You will have a column in the table "Recipes" something called as [Related Instructions for Each Recipes]

3. Please create a VC called say [All Instructions]  in the "Products" table with an expression something like 

SPLIT([Related Recipes][Related Instructions for Each Recipes],",")

Please make this [All Instructions]  column a list type column with element type as Ref and referenced table name as "Instructions for Each Recipes"

[NCD]

Thank you, will try!