Referential Integrity

<< Click to Display Table of Contents >>

Navigation:  TECHNICAL INFORMATION >

Referential Integrity

The DONATION program was very carefully programmed to protect you against silly errors which can cause big problems in the future. (Referential integrity is just a fancy Computer Science term for making sure that data in all of your related data files matches up sensibly.)

 

The following are never allowed:

 

-deleting a donor who has made donations this year
-deleting a donation category in which there are donations this year
-deleting a donor category that has already been assigned to donors this year
-changing a donation which has already had a receipt created for it (you may delete it, after confirming that is really what you want to do)
-entering donation dates that aren't in the current calendar year
-leaving important information blank, such as last name, or donation date, amount, or category
-entering two donors with the same Member/Envelope #

 

The following are allowed, but only after warning messages which give you a chance to change your mind about them, because they are questionable practices:

 

-changing the name of a donor who has made donations this year (because you may be changing them to be somebody else!)
-deleting a donation which has already had a receipt created for it (you would want to do this if a donation had been entered in error, and you needed to print off a corrected receipt)
-changing the name of a donation category in which there are already donations
-changing the name of a donor category that has already been assigned to donors
-creating two donors with the same first and last name (if you do have this situation, be very careful when entering their donations to check the address, so you know which is which!)

 

 


This topic was last edited on Mar 23, 2023