Hi Cathay:

Thank you for your kind response.

>I think you are saying that table A has Health#, FamilyHistory, PastHistory, and Allergies and it's one record per Health#.
Yes, and some more fields with demographic data and date fields. FamilyHistory, PastHistory and Allergies are all memo fields that can be updated.

Do I need to do the same for each field in TableA as you've shown in your example?

>Table B has Health# and Condition and can contain multiple records for a Health#.
Yes, and has RecordDate and ResolvedDate fields. Here is where each condition is recorded and the date resolved is also identified.

>Table C has Health# and Regiman and can contain multiple records for a Health#.
Yes, and includes fields for StartDate and EndDate.

>Table D has Health# and Consultants and can contain multiple records.
Yes, and includes a field to show when the referral was made.

>You want a 2-column report that prints all this information on one page for each Health#.

Yes. The user will make the selection.

>I hope I understood the problem and gave you enough information to help you solve it!!

Ofcourse you have Cathy and it is appreciated.