0 Replies Latest reply: Dec 4, 2012 6:40 AM by Adnan Sultan RSS

    Access column value from one straight table in another straight table

      I have two straight table

       

      for example:

       

      Straight Table 1:

      Column1, Column2, Column3, Column4

      a1          a2               a3          a4

      b1          b2               b3          b4

       

      Straight Table 2:

      Column21, Column22, Column23, Column24

      aa1          a1               12               22/2/2012 12:05

      ab1          a1               233             22/2/2012 17:05

      ac1          b1               333             22/2/2012 01:05

      ad1          d1               43               22/2/2012 12:55

       

      my question is how can i show the maximum value of Column24(Straight Table 2) in Straight Table 1 on basis of the Column1(Straight Table 1) and Column21(Straight Table 2).