Good day,
I have a current setup in Dataverse for my model driven with the below logic:
Tables:
- Requests
- Relationships: One to Many for Tasks | One to Many for Documents
- Tasks
- Relationships: Many to One for Requests | One to Many for Documents
- Every task will have to be linked to a parent request
- Documents
- Relationships: Many to one for Requests
- Every document MUST linked to a request
- Relationships: Many to one for Tasks
- Every document must be linked to a task but not mandatory to be linked to a request
In my model driven app on the Tasks form, I have a tab to show a subgrid of all documents related to that task
I would like to also add another subgrid to show all documents related to the parent request of the task
I'm not sure how this could be done - perhaps creating some sort of relationship to enable it?
Any help would be truly appreciated
Table Relationships:

Screenshot of my model driven app - Task Form with tabs

Thanks