Hello everyone,
in the attached database of a chemical lab, an analysis is made of some tests. A test is performed on one parameter and produces one outcome. Each test can be performed using one or more methods (maximum 3). Each parameter may have 0 or more (2 or 3 maximum) thresholds, according to some regulations.
I have been able to write a query which extracts all the required data, given the analysis ID (you can try the query with analysis ID = 7). Now I need to create a report, where all fields of anaysis are listed in the heading. Under the heading, I would like to have a table, listing all parameters, the methods adopted to measure that parameter, the outcome, the thresholds and the corresponding regulations. I think it should look like the attached pic.
I do not want that fields are multiplied according to the cardinality of the join. For example, I created a report in which methods were listed more than once, depending on how many regulations are applied, even if such fields are independent. If I use two methods to measure one parameter, and two regulations are applied to that parameter, I get 4 records. Something which I do not want to happen. Can you give me any help on this? thanks