Hi all,
Here's a simple problem that I can't quite figure out. I'm creating a database to keep track of donations. Contacts are in one table, and donations are in another. I want to create an update trigger to test if the amount was changed and, if so, add the amount to the persons total in the contacts table; but if the amt was not changed, to leave the total unchanged.

Bob Ohrstedt
Cleveland, OH