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'
I tried this https://support.wix.com/en/article/how-to-create-a-filter-by-dataset
![](https://static.wixstatic.com/media/a27d24_4e092bf16e4b4ef8821c1771f5970ad9~mv2.png/v1/fill/w_48,h_27,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_auto/a27d24_4e092bf16e4b4ef8821c1771f5970ad9~mv2.png)
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
![](https://static.wixstatic.com/media/a27d24_662e255798d64385b4b2043b5f2e2f40~mv2.png/v1/fill/w_49,h_7,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_auto/a27d24_662e255798d64385b4b2043b5f2e2f40~mv2.png)
Anybody ?
A little bit from column A and little bit from column B. Excuse the pun. ;)
Here the article I found: https://support.wix.com/en/article/wix-code-how-to-display-content-from-multiple-database-collections-using-reference-fields
Once you figure this out, it will open a lot of doors and even modify your approach. I have some pretty cool relational data working together.
same problem here too. looks like this is another broken wix feature.
Same problem! Did anyone help you? Did you solve it?