Calculate Weekly amount in Planned-Giving Database
I am creating a database for Planned-Giving in my parish. I need some guidance on how to calculate an amount base on 2 fields:
Frequency = Weekly, Fortnightly, Monthly, Quarterly, Half Yearly and Yearly
Amount Pledged = (Amount base on the Frequency)
The other field is a Calculation field (Weekly Amount). I want to calculation the weekly amount base on the Frequency.
I am new to Filemaker Pro therefore any help would be very grateful.