Hi,
Students
ID
name
surname
Absence
ID
Student_ID
absence_number
reason
so here each students have a lot of absent records, I want to show total absence per student, sum(Absence.absence_number):Students.absence_total works perfect.
The problem is if I show one to many relationship it shows lots of empty pages, I have do many to many relationship (group by Absent.ID) this time I cannot sort Students.absence_total I cannot even use in where clause. I want to make it with many to many relationship I think it is ideal. but how to sort and use it in where clause.
Students
ID
name
surname
Absence
ID
Student_ID
absence_number
reason
so here each students have a lot of absent records, I want to show total absence per student, sum(Absence.absence_number):Students.absence_total works perfect.
The problem is if I show one to many relationship it shows lots of empty pages, I have do many to many relationship (group by Absent.ID) this time I cannot sort Students.absence_total I cannot even use in where clause. I want to make it with many to many relationship I think it is ideal. but how to sort and use it in where clause.