Forum Discussion
Relationships between two tables not filtering properly
I have two tables: 1. The first query is where I get all my data for the reports. 2. The second query was created in order to define the targets for scrap for every material with a specific operati...
I think the problem is that you have an inactive relationship, presumably the one connecting operation number.
try removing the relationship between material and making operation number active, that would average over the material instead, which would be fine if each operation number is unique.
Otherwise if you create a new column in both tables along the lines of Material&OperationNumber, then you could use those columns to define the relationship. I don't find that solution very elegant, but I don't know of another.
If the operation numbers are not unique then try adding another table to filter both the MES data and scrap target by