In FM8, I have linked tables of Donors and Donations. Each month, I
make a report of Donors who have donated, which is easy because there
is a record of the Donation. How can I make a list of people who have
not donated? I think that I need to take the names of all donors and
subtract the names of those who donated. How do I do this?

In article <1164489637.168935.246970 (AT) h54g2000cwb (DOT) googlegroups.com>,
"Lee" <leehunt1 (AT) cox (DOT) net> wrote:

Set the Find to Omit the people who have donated. To do that, click the
Omit box in the control area of the layout.

--
For email, change <fake> to <earthlink>
Bill Collins

Bill wrote:
Bill, I still haven't figured this out. Here are my two basic tables:
-------- -------------------
Donor Donation
Table Table
-------- ------------------
Name--=---Name
-------- Donation Amt.
-------------------

Should I add Donation to the Donor Table? --Lee

In article <1164512851.419325.65630 (AT) 14g2000cws (DOT) googlegroups.com>, "Lee"
<leehunt1 (AT) cox (DOT) net> wrote:

How do you Perform the find for the existing Donation Report??
Is there a date involved somewhere (ie. this year, last year, etc.)??

If you're performing the Find in the Donor table, then you can simply
perform the same find and then choose "Show Omitted" in the Records
menu. This will swap the found set of records (those who have donated)
with the records not found (those who didn't donate).

If you're performing that Find in the Donation table, then you're in
for a bit more work. You'll need to instead create a new field in the
Donor table that let's you know this person has donated (this year?),
and you can then use this field to perform both finds.


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

In article <1164512851.419325.65630 (AT) 14g2000cws (DOT) googlegroups.com>,
"Lee" <leehunt1 (AT) cox (DOT) net> wrote:

To do the Find directly, you need a portal in the Donor table showing
related fields from the Donation table. The fields in the portal should
include Date.

Go to the Find mode. In the portal, set the donation date criteria to be
the current month. Click the Omit box in the control area. Perform find.
That will return all the Donors who do not have a donation date in the
current month.

To do a scripted Find, you do a variant the same thing, but within the
script:

Go to Donor layout
Enter Find mode
Set field Donation:ate = [desired date range]
Perform Find
Show omitted only


That script will first find the Donor records that have a donation
within the specified range, thus omitting those that do not, then will
show the omitted records only, which are the ones omitted in the Find.

--
For email, change <fake> to <earthlink>
Bill Collins

I still haven't figured this out. Here are my two tables with only
needed variables:
-------- -------------------
Donor Donation
Table Table
-------- ------------------
Name--=---Name
-------- Donation Amt.
Date
-------------------
I first do a find in the Donation Table by a month. This gives me
everyone who has donated. In some simple detail, what do I have to do
to get a list of names who have not donated?

Thanks!


Helpful Harry wrote:

In article <1164922690.909505.259290 (AT) 79g2000cws (DOT) googlegroups.com>,
"Lee" <leehunt1 (AT) cox (DOT) net> wrote:


In the Donor table, put a new field on a Layout and make it the Month
field from the Donation table (in the 'pick-a-field' window you can
choose the Relationship from the pop-up menu at the top and then the
window displays the fields from the related table).

No you can perform the same Find in the Donor table using this new
field - that gives you the "Has Donated" records.

To get the "Has Not Donated" records, simply perform this same Find and
then choose 'Show Omitted' from the Records menu. FileMaker will swap
the found records ("Has Donated") with the unfound records ("Have Not
Donated").



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

That is it...so simple! I had tried this before but had used the wrong
variable. Thanks for hanging with me, Harry! --Lee

Lee wrote: