>We're trying to identify a way in which we can delete a member, yet
>preserve the giving history of that member so that we can accurately tally
>giving for individual appeals, membership dues, and overall yearly giving.
Payment records are related to names records via a record number.
Deleting the names record will orphan the payment (and action, and
contact) records. Do you really want to delete the former member's
record? Do you not have other non-member records (prospects, other
contacts, for example) in your file?
>Deleting a member unfortunately also deletes that member's giving history.
>We've thought about flagging any deletes and keeping them in our file, but
>this poses the problem of having to omit the deletes in any finds or
>queries -- and ensuring our dozen staff do so as well.
Most people keep many other kinds of records in the main names file
as well as members. That's why there are member status fields,
affiliation fields, and the like. It's very easy to search for
current members if that's who you want to do a mailing to.
--
Dave Shaw Northwest Classics, Inc
tel: 206-954-7526 fax: 206-625-1338
------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address
you used to subscribe to the ebase support list:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
