Hi all:

Data source fo this report is from 4 different tables. The first source contains a health number and 3 memo fields which are updated to refelct fmaily histroy, allergies etc. Therefore, there will only be one record per client in this table. The remaining tables have a field that stores the health number and other fields such as current condition, treatment plan and the like. Difference here is that there can be more than one record for a client in each of these tables with variations between each table.

All of the data are in cursors and are then assigned to variables.

Goal: To achieve a 2 column report that can be updated and filed in each chart. The desired layout is:

- Personal & Family Data - Ongoing Health
(from mPersonalData) (from mCondition)



- Past History