Hi, I'm a new user just getting used to FM. I am trying to create a database that records donations for a charity. The senario is that people give either irregularly and/or varing amounts. At the end of each month I need to print receipts to be sent out to the donors from that month. For each donor I have Jan - Dec fields with values of '0' if no donation or a value if they made a donation. What I am trying to do is create a script that looks at the current months donation value on the donors layout and inserts it into a current month donation on a receipt layout. But nothing I am doing seems to work. HELP please!

-JB

I recomend that you start over. You need to have 2 files (tables) One contains the information about the donor. A Donor ID which is a serial number generated by FMP. The donor name, address, city, state, zip, phone number, etc. The second contains the information about the donation. The Donor ID, the date, the amount. I would add a calculated field Year Month = 100 * Year (Donation Date) + Month (Donation Date). This will be used to find the donations for a month. A summary field to total the donations will also be needed.

Print your receipts from the second file. Find the donations from the Year Month then sort by Donor ID. Use a list layout.