10 Replies Latest reply: May 13, 2015 7:48 PM by Marcelo Fonseca RSS

    Filter table based on other Table

      Table1

      IDDate1Date2
      ID101/01/201402/02/2014
      ID203/03/201404/04/2014

       

       

      Table2

      IDTypeActivityDate1
      ID1AA01/02/2015
      ID1BA01/03/2015
      ID2BB20/02/2015

       

       

      TableConsolidated:

      IDDateFrom
      ID101/01/2014Table1
      ID102/02/2014Table1
      ID203/03/2014Table1
      ID204/04/2014Table1
      ID101/02/2015Table2
      ID101/03/2015Table2
      ID220/02/2015Table2

       

       

      Hi, i am working on a report like the example above, where i have two tables in different formats which consolidated in tableConsolidated. Now i want to filter the TableConsolidated based on the fields from Table2, using the fields Type, Activity or any other field from this table. I Assume that since i link the 2 tables based on the field ID i could do this, but when i try to filter the field 'Type' selecting 'A', the TableConsolidated shows the result below:

       

       

      DDateFrom
      ID101/01/2014Table1
      ID102/02/2014Table1
      ID101/02/2015Table2
      ID101/03/2015Table2

       

      What i expect was only the dates that has an "A" in the "'Type" field. What kind of link do i have to do? In my complete table i have more than 20 field from table2 that i wish to filter in TableConsolidated