hi,
thank you very much,
if i put Thisform.Grid1.ColumnCount = 12
i see aother fields as header1,......header10

but if i put it as MR.Alex Feldstein answer
Thisform.Grid1.ColumnCount = -1
it works, with the same fields name.

thank you again.
best regards.
m.qasem



>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.