Field Repetitions Really Necessary? HELP!

[Mark L]

It

[Brian C]

I think you need to create a separate table to store all of this information and use a category field to keep specific records grouped together for purposes of summarizing the data.

Use a relationship from this new child file to bring across data from the parent file for reporting purposes.

You can then create subsummaries that will break on predictable sorts to display the information as you like.

If the data is sorted: Patient, Category, Record Sequence #

1) Subsummary before the body with sort broken on patient can be used to display the patient information.

2) Subsummary after or before the body with sort broken by the category can be used to summarize the particular information that is listed in the body for that categorey of the specific patient

[Mark L]

Hi Brian,

Thanks for reponding to the post.

I'm quite sure I follow - so let me ask you some questions:

"...create a separate table to store all of this information..." - Do you mean a single table? How would that table connect to the existing tables - or would it?

Thanks,

Mark