L
LongWayFromHome
This one is driving me nuts. I need to show two types of related data from
the same table in the same report.
I send endowment reports which include a Change of Address card showing the
recipient's address as we have it. The card also invites the recipient to
tell me to send the report to others. To avoid wasting the recipient's time,
the card also lists everybody else already receiving the report. (Those
OTHER recipients receive cards with the converse information. I hope this is
clear.)
Both the recipient address and the other-recipient address(es) are in the
same table. Here are the related tables, which allow mix-n-match of
recipients and endowments:
RecipientTbl: contains name, addr, unique ID#
EndowTbl: contains endowment name, unique ID#
MatchTbl: contains Recipient ID matched with Endow ID.
What is the best approach to querying this so that each card shows the two
types of related data from the same table? Do I need a subreport for the
other receipients?
Thanks!
the same table in the same report.
I send endowment reports which include a Change of Address card showing the
recipient's address as we have it. The card also invites the recipient to
tell me to send the report to others. To avoid wasting the recipient's time,
the card also lists everybody else already receiving the report. (Those
OTHER recipients receive cards with the converse information. I hope this is
clear.)
Both the recipient address and the other-recipient address(es) are in the
same table. Here are the related tables, which allow mix-n-match of
recipients and endowments:
RecipientTbl: contains name, addr, unique ID#
EndowTbl: contains endowment name, unique ID#
MatchTbl: contains Recipient ID matched with Endow ID.
What is the best approach to querying this so that each card shows the two
types of related data from the same table? Do I need a subreport for the
other receipients?
Thanks!