Buy Now
Sign in

multiple matching records sorting problem

samir1903 , January 29 2021, 00:18
S
samir1903 185
January 29 2021, 00:18 #395775
hi i have two tables
students and attendance tables
foreign key in attendence multi matching records relationship
listing students and want to see each attendence per students
Janny 12
Mat 2
Alex 5
attendance until here i can make it with goup forign key of attendence but i cannot make sorting my attendce from higher lower or from lower to hgher
S
samir1903 185
January 29 2021, 15:54 #395784
Estudiantes fields to retrieve
SUM(Students.attendence _number):Students.attendence_total
if i connect one to one this pagination shows like that too many pages blank
if i connect multiple relationship then pagionation works well but i caanot use Students.attendence_total for sorting
i dont know how to solve this
chrono1.jpg
chrono2.jpg
chrono3.png
Attachments
chrono1.jpg
chrono1.jpg
(90.09 KiB)
110 Downloads/Views
chrono2.jpg
chrono2.jpg
(89.21 KiB)
84 Downloads/Views
chrono3.png
chrono3.png
(5.25 KiB)
87 Downloads/Views