I have a database "Workshop" that contains basic informations and list of activities that comes from another table "Activities" that contains different workshop activities
Workshop Table
- ID
- Name
- Description
- Activities (List) (Document Reference)
Activity Table
- ID
- Name
- Description
I create a dynamic list to display all My Workshops from my Workshop Table and display related activities for each workshop.
So I retrieve something like this:
Workshop A
Activity ID x
Activity ID y
Activity ID z
Workshop B
Activity ID a
Activity ID b
Activity ID c
Activity ID d
But I don't want activity ID. I need to retrieve activity Name & Description so I have added a Query (Get Document From Reference) on the First Children of the Dynamic List where I pass the Document ID I retrieve.
Problem is I get an infinite Loader and nothing shows up.