Basically I have a table with a product list and 2 binary fields, such as, requires signature, requires tracking.

Then I have a list of couriers, that also have those 2 boolean fields.

I want to return a list of all couriers we can use for a specific product, knowing that a product that has yes in one binary field needs a yes in the other one. But no can have a yes or no on the other table.

```
ProductNumber trackingrequired signaturerequired
123               yes                     no

CourierID trackingrequired signaturerequired
1                    yes                     yes
2                    no                       no
3                    yes                     no
4                   no                       yes
5                    yes                     no

```

Query would return 1 3 and 5:

```
ProductNumber CourierID
123              1
123              3
123              5

```

Since the signature is not required, the data on the second column is irrelevant for this case. I'm happy to change the way the data is stored if necessary. 
I am using MSAcess.