Modification Date Problem
Hello, I've got a simple two table database. One table is "Donors" which has very basic information like name, address, phone. The other table is "Gifts" which stores individual gifts given by donors. The "Gifts" show up in a porthole on the Donor layout. My problem is that we use the modification date to see when donors have given but the modification date only changes if we make a change to the donor's contact info such as a new phone number or change to their address.
Is there a way to make modification date in the Donors database change if a new gift is added OR if their contact info has been tweaked? If so, how?
Thanks for any help you can provide.