too many fields for report

[reportyemi]

I created a patient record as a form and now want to create a report that
will allow me to print the patient record. The report wizard however states
i have too many fields and cannot create the report. Can someone help with
this issue? I want to be able to print one patient record at a time

THanks

Yemi

 

[Allen Browne]

The solution will probably be to break your big wide table with lots of
fields down into a normalzied design.

For example:
- One patient can be admitted many times
- One admission can have mutiple observations
- One admission can be for multiple diagnoses
- One admission can have multiple interventions
- One intervention can have multiple treatments
and so on.

This will give you far fewer fields across any table: instead of lots of
fields (such as Observation1, Observation2, ...), you have many *records* in
the related table.

If you alreay have a fully normlized design, the solution will be to remove
some of the tables from the big query you are using for your report, and use
a subereport.

Normalization is a *big* field. Here's a basic example:
Relationships between Tables (School Grades example)
at:
http://allenbrowne.com/casu-06.html
and here's a bunch more links:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html#DatabaseDesign101