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 :-(