I'm a newb. and am stuck trying to figure out how to set up (change, really) our current donation tracking system. We have a Contacts table (1 record per person), a Donation Tracking table (1 record per donation) and a Company table (1 record per company). Each Contact can have many donations. Many Contacts can be with 1 company. The problem is that when a Company donation (meaning the company wrote a check) comes in, I record it in under an individual Contact at that company. If I don't choose the same Contact each time then I could (do) have several Company donations distributed among several contacts and I'd rather they be connected to the Company, so I can get summaries easily for that company. Do I have to change my Donation Tracking table to Individual_Donation Tracking and ADD a Company_Donation Tracking table? Or can I relate the current Donation Tracking table records to companies and individuals? which way is better? thanks for any advice.

There used to be a free file available to Non-Profits at FileMakerinc.com called "Donations"