M.

By "...but if i hide the command window via X, i see all fields at mygrid" do you mean "... in a browse window"?

Is your grid already designed? How many columns does it have (Grid1.ColumnCount)?
After creating your cursor you can issue:

Thisform.Grid1.ColumnCount = 13

... to accommodate all the fields in your cursor.

Terry

>hi all,
>any idea,
>
>i try with this code under,
>but i see only the 5 fields at my grid,
>
>but if i hide the command window via X, i see all fields at mygrid
>

>
>Select course.coursenumb, course.coursename, ;
>       table2.g1, table2.g2, table2.wm1, table2.g3, table2.tot1, ;
>        table2.g4, table2.g5, table2.wm2, table2.g6, table2.tot2, table2.ltot  ;
>        from Course ;
>  inner join TABLE2 on table2.no = course.no ;
>  into cursor csrCourseStats readwrite
>
>Thisform.Grid1.RecordSource = "csrCourseStats"
>
>

>thanks.