hi,
thank you very much,
it works ,as what i need exactly,
i can see now at my grid all fields with the same number as text1.
thanks again
best regards
m.qasem
>You can do this that way:
>
>

>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"))
>