Summary Reports Help
I am trying to make a report of all Pain relieving strategies for patients in hospitals. There are 3 tables, Patients, Assessments and Analgesia. The Analgesia table records details of one of 3 strategies for proving pain relief following operations. THe details of the Operation and Patient details are stored in the Patient layout. THere is a portal in the Assessment layout to the Patient layout.
When I try to make a report to show the details of one of the pain strategies (I have to use fields from all 3 Tables) I find that under labels of fields from the Current table (Analgesia) the information displayed relates to the patients in question but that under the related fields information for all patients is displayed!