YAY... I've managed to get the receipt working as I wanted. I did three things...
- Changed some field names so as to remove all possibility of confusion on joins.
- Changed the report to follow the DonorID.
- Relocated the data for Tier 2 into the header for Tier 2. (oops - this I believe to have been the real issue)
I wanted to get records only from Donor Z...
The Receipt was to show above in first third of page. (easy part)
--------------------------------------------------------------------
Followed by a dotted line and then details from which the year end receipt came.
Details:
Z's first donation from Table.Donations against the margin (Tier 2)Details for that donation from Table.Items (Tier 3)
Z's second donation against margin (T2)Details for that donation from Table.Items (Tier 3)
Etc for all records that match for the year.
Spent a lot of time trying to make it work, came in frustration, and today, after a few hours work, figured it out.
Thanks anyway. Am posting answer in case it helps someone else.
Gary