hi,
this is the fields.

Select bookno,sticket,eticket,NOOFTICKET,BOXNO,shipno,trans_type from trans1 into cursor csrmyCursor readwrite where .F.
SELECT csrMyCursor
With thisform.Grid1
  .RecordSource = "csrMyCursor"
  .Columncount = 7
  .Column1.ControlSource = "csrMyCursor.bookno"
  .Column2.ControlSource = "csrMyCursor.sticket"
  .Column3.ControlSource = "csrMyCursor.eticket"
  .Column4.ControlSource = "csrMyCursor.noofticket"
  .Column5.ControlSource = "csrMyCursor.boxno"
  .Column6.ControlSource = "csrMyCursor.shipno"
.Column7.ControlSource = "csrMyCursor.trans_type"
    append blank
  .Refresh()
ENDWITH

>I am sure that you don't have a FIELD called bookno.sticket.eticket in your csrCourse cursor???
>
>>hi,
>>thank you,
>>i try as under, but still take the empty records
>>

>>   Append from dbf('csrMyCursor') for !empty('csrMyCursor.bookno.sticket.eticket')
>>

>>
>>thanks
>>
>>
>>>Append from dbf('csrCourse') for !empty(csrCourse.somefield) && Replace somefield with a real field name!
>>>
>>>>hi all,
>>>>any idea,help
>>>>
>>>>i need to append at my table only records not empty from my grid1(csrCourse)
>>>>
>>>>APPEND FROM (DBF("csrCourse"))&& only record!empty
>>>>
>>>>thanks