Need help with Nested Lookups

1

Hello,

My scenario is I have 3 tables linked hierarchically
Table 1 called Epics and a column Features which is a lookup to Table 2 - Features
Table 2 called Features and a column Tasks which is a lookup to Table 3 - Tasks
Table 3 called Tasks

In Table 1 - Epics, I want to add a column “Features + Tasks” so that for each Epic I can list the Features and its related tasks. something like

  • Epic 1
    • Feature 1
      • Task 1
      • Task 2
    • Feature 2
      • Task 3
      • Task 4
  • Epic 2
    • Feature 3
      • Task 5
      • Task 6
    • Feature 4
      • Task 7
      • Task 8
        and so on…

Thx in advance.

2

hey @Ratish_Gupta I posted something similar here Data Hierarchy and Aggregration - see if it helps