I'm trying to create a script to find records using checkboxes for several fields. A simplified version of my goal is to be able to find cars based on color and brand. I get this to work fine if only filtering based on one field, say finding all green and blue cars. I also manage to find the right records if I only use one criteria for each field, say green volvos.
But I'd also like to constrain across fields, say by also ticking off volvo and audi, such that the found set would include blue or green volvos and blue and green audis. This is where I run into problems.