I have a table for students' details in a school.unique is their roll number in rows.coloumns are age,sex,grade etc.There is one coloumn vacant for lot no.I want to place equal number of students under one lot number.Then same numbers under another.If there is 60 stuednts.Group them as a,b,c,d,e,f.six group.60/10=6.For the first 10 studets lot no should be generated randomly and should be same.Next 10 students should have same lot no with random generation.User should enter his?her desired lot no after seeing number of records.e.g_if user sees ,there is 54 records,and wants to devide them in 6 groups with 9 students in each group.He/she should enter lot size=6.after saving that number the records should be automatically devided into 6 groups with generation of random numbers with same for 1st 9 students,then same for next 9.but user should calculate the groups he wants to devide.No pagination required.Lot no may vary from user to user and data may be different.might be 60 records or 81.81 means,if he enters lot no=9,9 records under one lot number
Enter LOT size you want:text box .Save button
RollNo Age Sex Location Lot No
452345 4 M ty Empty
545454 6 M 5y Empty
767568 7 M hy Empty
203392 9 M ty Empty
After entering 2,recodrs should be devided into 2 groups with generation of same lot no for first two,and same for next two records.This design is final.please help me.Likewise we can create for 20,30,40 students.
Please help me.plizz it s very urgent.My deadline is near.Thank you.