>First, I don't see the third table in your example. Second, what is relationship between those tables (2 or 3)? Can you show an example how do you want you data to look on report?
>
Hi Sergey:

I currently have written code for 2 tables only and will be including the 3rd.

select a.*, b.PresRef, b.MedName, b.OrderDate, b.PhysRef;
	from Physicals a, Prescriptions b;
	into cursor ViewPhysicalsReport nofilter;
	where a.Healthnum = mRepHealthNum .and.;
		a.Date = mPhysicalsDate .and.;
		b.PhysRef = a.PhysRef;
	order by a.PatientNam, a.HealthNum, a.PhysRef, b.MedName

Desired Report:

REPORT HEADING
Report Date:
Doctor:
Patient Name:                              Date of Physicals:
_____________________________________________________________

BP:     HR:   etc........

General Appearance:
Head and Neck: 
......
...... (all from physicals table)

Prescriptions:  (list all medications prescribed)

Labtests:  (list all labtests ordered) (this is the 3rd table)

Diagnosis: (from Physicals table)
Management: (from Physicals table)
Progress: (from Physicals table)
____________________________________________________________
Page number

Relationship: All tables are related by date and PhysRef.

Thanks.

Ravi