I suspect what I am trying to achieve may have to do with how I link tables, but I am very weak on this topic.
I have an Operator table, a table for Patient_results and a table for Control_results. Operator ID is the field linking the Operator table to the Patient table and the operator table to the Control table. The two links are the default type (inner join, not enforced, =). There is no relationship between the patient result table and the control table. I want a report that shows all the results for an operator ID in a given period; both patient and control results. A detail line in the report should have a line for each control result (with nothing in the patient result field) and a line for each patient result (with nothing in the contol result field). Of course, I am getting loopy results as the detail line tries to put both control and patient results on a detail line and there is no relationship.
I am using CR ver 11.
I have an Operator table, a table for Patient_results and a table for Control_results. Operator ID is the field linking the Operator table to the Patient table and the operator table to the Control table. The two links are the default type (inner join, not enforced, =). There is no relationship between the patient result table and the control table. I want a report that shows all the results for an operator ID in a given period; both patient and control results. A detail line in the report should have a line for each control result (with nothing in the patient result field) and a line for each patient result (with nothing in the contol result field). Of course, I am getting loopy results as the detail line tries to put both control and patient results on a detail line and there is no relationship.
I am using CR ver 11.