help creating DB for school lunch program
I haven't used Filemaker in 6 years and at a loss. Using FMP ver 10 on a mac. The school I work in wants a DB created to track lunch provided to students. The categories for students are: Free, Reduced ($0.25), and full pay ($1.50). Students are tracked by number category: A=free 1= free 2=reduced 3= full pay 4=full pay and 5=full pay. There are 480 students. They want to know: How many free, reduced, and full pay lunches are served DAILY, and invoices printed WEEKLY delivered to each student (just name and class.. no mailing address needed) detailing what each family owes for lunch. This again is a weekly printout. Of course once payment is made, it's reflected in the database.
I've created these fields for each of the 480 students and have the data already entered from an excel spreadsheet. :
Meal code (see above)
Calendar (date field with a calendar popup for easy date entry
Price code ( a calculated field that reflect the meal code: If ( Meal Code = 3; 1.5 ; If ( Meal Code =2 ; .25 ; If ( Meal Code=4 ; 1.5 ; If ( Meal Code=5 ; 1.5 ; If ( Meal Code=1 ; 0 ; If ( Meal Code="A" ; 0 ; If ( Meal Code=" " ; 0 ; If (Meal Code=1 ; 0 ; 0 ))))))))
(there are 2 students without meal codes so I entered " " they are free so it produced $0.00
That's as far as I got. ANY HELP greatly appreciated.