I have 3 tables shown below. While selecting Project# in Table 1, I am getting result in Table 2 correctly. But that is not reflecting in TABLE 3. For instance, highlighted in yellow color. 1C->C1,C2 with Status Complete in Table 2. But all status from Table 3 coming along with Table 2. If the status is Complete in Table 2, the Table 3 status should be Complete. But here both status are associated when selecting Complete in Table 2.
If I select the highlighted ParentID in Table 1, result should come accordingly. But I am getting T3 Status as Complete and In Complete for T3 UID. The output I got shown below the excel data
