myNewNo = thisform.text1.valie

Select course.coursenumb, course.coursename, ;
       table2.g1, table2.g2, table2.wm1, table2.g3, table2.tot1, ;
       table2.chr1, table2.g4, table2.g5, table2.wm1, table2.g6, table2.tot2, table2.ltot, table2.chr2, ;
       myNewNo AS No;
  from Course ;
  inner join TABLE2 on table2.no = course.no ;
  into cursor csrCourseStats

Thisform.Grid1.RecordSource = "csrCourseStats"

LOCAL lbFlUsed
IF NOT USED("Stud")
   USE Stud IN 0
   lbFlUsed = .t.
ENDIF
SELECT Stud
APPEND FROM (DBF("csrCourseStats"))