I want to get this report.
If one student want to read all (6) subject then fee will be dvided on subject percentage.
or if the student want to read 2 or 3 subject then amount will be divided on subject amount not in percentage...
Report Query is
SELECT DISTINCT TP.TCLASS, TPD.TSUB, TPD.TPCT, TPD.TPM, STUDENT.ID,
STUDENT.GROP, STUDENT.NAME || ' / ' ||STUDENT.F_NAME Na, FEE.RECP
FROM FEE, STUDENT, TP, TPD
WHERE ((FEE.ID = STUDENT.ID)
AND (TPD.TDATE = TP.TDATE
AND TPD.TID = TP.TID)
AND (TP.TCLASS = STUDENT.CLASS))
order by student.id