Only show results in one table, that are visible in another table
I have filtered out some order numbers in table 1, and this table now contains only e.g. 5 different order numbers.
I have another table (table 2) with all order numbers, this table contains much more detailed data about the orders than table 1. But I want table 2 to only show those 5 different order numbers from table 1.
It is not possible to filter out the orders in table 2 as I have done in table 1, as the criteria for filtering conflicts with the detailed data, I want to show in table 2.
Is it possible to make a connection between table 1 and 2, so table 2 only shows the order numbers visible in table 1? Please note, the report is dynamic; the order numbers in table 1 will change every week.