So, I am creating a database for a charitable organization.
I have a donations table and then, for legal purposes a separate receipt
table.
I am using an append query to generate the records in the receipt table.
However, first I am searching for all open donations by each donor and
aggregating these into a single receipt.
However, the problem is re-connecting the receipt to the donation(s) after
the append. Is there any way that I can create a field in the append query
that includes a list of the primary keys of all relevant donations that I
can
separate out later to create the "details" section of the receipt.
The problem that I am finding is that my query is pulling up old donations
that match the donor name, address and receipt to fields, which is what I
have linked between the tables. If I could link by donation that would be
the
most secure method, but given the aggregation business, it is not so
simple.
Any help is massively appreciated.
Cheers,
Talia
|
