hi,
thank you.
>>1.but
>> I see all fields i have at my table i need to see only the 3 field i choise.
>
>
>Select * from trans1 into cursor csrmyCursor readwrite where .F.
>SELECT csrMyCursor
>With thisform.Grid1
> .RecordSource = "csrMyCursor"
> .ColumnCount = 3
> .Column1.ControlSource = "csrMyCursor.bookno"
> .Column2.ControlSource = "csrMyCursor.sticket"
> .Column3.ControlSource = "csrMyCursor.eticket"
> append blank
> .Refresh()
>ENDWITH
>
>
>>2.I need to append new record at the last field at myGRID if this field not empty.
>
>Thisform.Grid1.AllowAddNew = .T.
>
>and then you will need to use the Afterrowcolchange event and in there figure out which row you were on and which column you were in so you can determine if you need to append blank and Thisform.grid1.refresh() or not. It is not pretty, easier to teach your users to press down arrow to add a record then you only need the AllowAddNew property set.