Master - Detail - Detail - Detail


I am trying to build a slightly complex report.

In essence I have

Master Record - A Pet Owner

They can own Multiple Pets

Each Pet can have Multiple medical conditions

(I split my data into Owner. Pets and Name and Summary, Pet summary medical page, Pet Medical conditions)

Owner to Pets Name and Summary and Pet summary medical linked on an ID

and then Pet Summary page to Conditions linked on a different ID.

I need to Produce a report that shows

Letter to Owner

Information to Owner showing his pet names and details

A new page for each pet showing their age, summary of their conditions and exclusions

A list of their conditions

I have tried building it with a Master record (Owner)

Group detail Pet

Group detail Summary medical conditions

But the issue with this is that then I cannot get the conditons for each pet to follow.

Does any one have any suggestions?

I am debating dropping the conditions table but this would then adding lots of fields to the end of the pet summary medical page and then manually adding via code the conditions to the report.

I am a little stuck :-(




Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.