You will need to pull all the data from all the tables into one cursor, adding a new field to the cursor which indicates which table each record came from. To create the illusion of multiple detail bands, you need to add multiple controls to the detail band and set the "Print When" logic to only print when the new field = a certain value. It gets messy because you have to stack all the fields on top of each other.

Cathy


>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.