Table1
| ID | Date1 | Date2 |
|---|
| ID1 | 01/01/2014 | 02/02/2014 |
| ID2 | 03/03/2014 | 04/04/2014 |
Table2
| ID | Type | Activity | Date1 |
|---|
| ID1 | A | A | 01/02/2015 |
| ID1 | B | A | 01/03/2015 |
| ID2 | B | B | 20/02/2015 |
TableConsolidated:
| ID | Date | From |
|---|
| ID1 | 01/01/2014 | Table1 |
| ID1 | 02/02/2014 | Table1 |
| ID2 | 03/03/2014 | Table1 |
| ID2 | 04/04/2014 | Table1 |
| ID1 | 01/02/2015 | Table2 |
| ID1 | 01/03/2015 | Table2 |
| ID2 | 20/02/2015 | Table2 |
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:
| D | Date | From |
|---|
| ID1 | 01/01/2014 | Table1 |
| ID1 | 02/02/2014 | Table1 |
| ID1 | 01/02/2015 | Table2 |
| ID1 | 01/03/2015 | Table2 |
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
