HI All
I want to print a report that displays all the patients for a doctor with the code of each patient's disease.
After this part I want to print a cumulative of each code of disease for patients of this doctor.

I have a table that contains all patients of the doctor and another that contains the cumulative codes, these two tables are linked by a relation with the medical code.

it look like this


First table Alias

Nom Med Code1 Code 2 Code 3
Mr xxxxx 123 8800 8802 8803
Mr. YYY 123 8800
Mr. AAA 123 8802 8804


Second Table

Med Code Qty
123 8800 2
123 8802 2
123 8803 1


How can i print the first table informatyion and after that the second one
I have Try to put the fields of the second table in the 2 second detail band and i have write the name of the second table in the taget Alias expression but the best i have got is something like this.


Mr xxxxx 123 8800 8802 8803
123 8800 2
123 8802 2
123 8803 1

Mr. YYY 123 8800
123 8800 2
123 8802 2
123 8803 1

Mr. AAA 123 8802 8804
123 8800 2
123 8802 2
123 8803 1


Can you help me

TIA
Ben.