I do not quite understand the problem (in detail), I only get the gist of it.
Please have a look at Filtering Database Query with Multiple Checkboxes and see if that helps
If not, then have a look at using one Server Connect and multiple Data Views