I have one list, called "Company Reports" and another list "Companies"
The Companies list has a field called Include(yes/no), and I have created a View which filters it to only show active companies.
Now when I try to connect the first list to then second to filter the Company Reports by Included companies, I always get all the Company's Reports.
In SQL this would be something like:
SELECT * FROM CompanyReports INNER JOIN Companies ON CompanyReports.CompanyName = Companies.Name WHERE Companies.Include = 1
Is the WP Connection ignoring the Filter defined in the View of the Companies?
Is there any way to make it work this way?