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                              - Medications
(from mPastHist)                              (from mRegimen)



- Allergies                                 - Consultations
(from mAllergies)                             (from mConsultants)

This should preferably be on one page.

I developed an initial report, with just one detail band and placed controls for mPersonalData, mPastHist and mAllergies. The out come was that even though there was only 1 record in mPersonalData, it was displyed 3 times.
Not sure waht the problem is.

Your guidance is greatly appreciated. Thank you.