3 Replies Latest reply: Sep 17, 2017 8:36 PM by Arnaldo Sandoval RSS

    Link Key Logic

    RAM MUTHIAH M

      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.

       

      Table 1:                              


      Project#

      Parent ID

      1

      1A

      1

      1B

      1

      1C

      1

      1D

      1

      1E

       

        Table 2:


      T2Parent ID

      T2UID

      T2Date

      T2Status

      1A

      A1

      22/10/2015

      Complete

      1A

      A2

      3/11/2015

      In Complete

      1B

      B1

      30/12/2015

      Complete

      1B

      B2

      21/11/2017

      Complete

      1C

      C1

      2/10/2017

      Complete

      1C

      C2

      13/04/2018

      Complete

      1D

      D1

      28/12/2015

      In Complete

      1D

      D2

      22/11/2017

      Complete

      1E

      E1

      20/10/2017

      In Complete

      1E

      E2

      22/10/2015

      In Complete

       

      Table 3:

       

      T3Parent ID

      T3UID

      T3Date

      T3 Status

      blabla -1A

      A1

      24/10/2015

      Complete

      blabla-blabla -1A

      A2

      5/11/2015

      In Complete

      blabla-bla/ -bla -1B

      B1

      31/12/2015

      Complete

      blabla-bla* -bla -1B

      B2

      25/11/2017

      Complete

      blabla-bla/ -bla -1C

      C1

      4/10/2017

      Complete

      blabla-bla -bla -1C

      C2

      15/04/2018

      Complete

      blabla-bla/ -bla -1D

      D1

      38/12/2015

      In Complete

      blabla-bla/ -bla -1D

      D2

      25/11/2017

      Complete

      blabla-bla/ -bla -1E

      E1

      22/10/2017

      In Complete

      blabla-bla/ -bla -1E

      E2

      25/10/2015

      In Complete

        • Re: Link Key Logic
          Andrea Gigliotti

          could you please explain better which field are you selecting and what's the output expected ?

            • Re: Link Key Logic
              RAM MUTHIAH M

              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

               

              T3Parent ID

              T3UID

              T3Date

              T3 Status

              blabla -1A

              A1

              24/10/2015

              Complete

              blabla-blabla -1A

              A2

              5/11/2015

              In Complete

              blabla-bla/ -bla -1B

              B1

              31/12/2015

              Complete

              blabla-bla* -bla -1B

              B2

              25/11/2017

              Complete

              blabla-bla/ -bla -1C

              C1

              4/10/2017

              Complete

              blabla-bla -bla -1C

              C2

              15/04/2018

              Complete

              blabla-bla/ -bla -1D

              D1

              38/12/2015

              In Complete

              blabla-bla/ -bla -1D

              D2

              25/11/2017

              Complete

              blabla-bla/ -bla -1E

              E1

              22/10/2017

              In Complete

              blabla-bla/ -bla -1E

              E2

              25/10/2015

              In Complete

               

              T3 UID   T3 Status

               

              C1     -    Complete

              C1     -    InComplete

              C2     -    Complete

              C2     -    InComplete