I am having some problem with Dataset Filtering, bit difficult to explain.
I have a Master Database named 'ArrivalsDatabase'
& I have another Database named 'ArrivalsDB'
Now, inside both databases there is a column named 'fileNumber'
In the Master Database the list is very long and contains dozens of 'fileNumber' along with other information such as 'email'
However in my small Database 'ArrivalsDB' the number of 'fileNumber' is very small but it does not contain the associated emails, that is only available in the Master Database
I have a Table on my page and I have connected it to the Master Database 'ArrivalsDatabase' but I want to display only those rows whose 'fileNumber' is present in both 'ArrivalsDatabase' and 'ArrivalsDB'
There are a total of 3 'fileNumber' matches between my 2 databases so by applying the above Dataset Filter I should be seeing all the 3 rows associated with the fileNumbers but instead I am seeing only 1