Creating a subforum with information from two separate tables.

[Tamika]

Please see below......
*************************************************
Subject: Re: Totally Confused
From: "Tamika" <[email protected]> Sent:
8/18/2003 7:57:50 AM




I'm sorry, maybe I wasn't clear enough...

Okay I do have 3 tables. {Well actually more, but I don't
think they matter right now.
1. Donors
2. Donations
3. Pledges

Pledges DO NOT turn into Donations but both donations and
pledges are gifts.

On both the Donations and Pledges have the field DonorID.
Thus linking them to the Donors table.

Each donor gives a "gift", the "gift" is designated to a
particular fund. I would like to produce a form that is
donor specific that can be viewed as a subform on the
Donor form which reflects the each "gift" the donor has
given, the amount of the gift, and the date. I would like
it to be a tabular form with the following fields:
"Fund" "Gift Date" "Gift Amount".

I would like the fields to reflect all gifts that have
come in- both donations & pledges. Even if the pledges
aren't paid.

Is this possible?

 

[John Vinson]

I would like the fields to reflect all gifts that have
come in- both donations & pledges. Even if the pledges
aren't paid.

Is this possible?

Try basing the Subform on a UNION query splicing together the
donations table and the pledges table. See the online help for UNION,
or post back if it's not clear.

Note that the subform will not be updateable, since Access can't tell
which table you might want to create a new record in.