>Dear all
>I have a child table and try to creat new command botton for adding a new record on the child table. But how to make the cursor move to the new line and first colunm automatically? (in the grid).

Look at the SetFocus method for the grid/column/control for this

>
>And automatically sort by the first column after adding it.

Might need to add an index to the table/cursor on the field bound to the column and have that index active for the table/cursor.

>
>Also my delete command botton won't get rid of the record. It shows still and I already put thisform.refresh. Sometime it works, sometime, it doesn't

Probably need to add some code for the delete like:

THISFORM.LOCKSCREEN = .T.
DELETE
SKIP
IF EOF()
    GO BOTTOM
ENDIF
THISFORM.MyGrid.REFRESH
THISFORM.MyGrid.SETFOCUS
THIS.SETFOCUS    && If you used a button to fire the delete
THISFORM.LOCKSCREEN = .F.

>
>Thanks a lot
>
>Have a great weekend!!!