Attaching Multi Data Tables

Greetings,

I have to use a scenario to explain due to confidentiality. I have a bakery and I am trying to connect production to the quality records by the following:

1. Connecting cleaning results by the tanks used by production to make the dough

2. Connecting quality records by the lot numbers used by production to identify the dough.

I have a master date table the sanitation, production, and quality records are tied to.

The report filters by date. Then the material number. I am able to get the material for that week and then click on the material number.

However when I filter this way I get all the quality records from that date instead of just the lot number.

And when I filter this way I get all the sanitation for that time, however, I need it to cover a 30-day spread because we may not wash it the same day its made. 

When I try to join say the production with the quality I get a relationship error.

When I try to join say the production with sanitation I get there is no relationship error as well.

Picture show relations as color coded ink.