>Hi,
>I have created a simple for customer maintenance. After I delete the record, the record still appear on my screen. I found that the record has been mark deleted, but it still been extracted out from the customer table.
>
>Can anyone tell me how to filter the deleted record from displaying in the grid of my program?
>
>Thank U and have a good day.

Issue SET DELETED ON on your main program. If your form uses 2-private datasession, issue set deleted on at load event of the FORM.

After the issuance of the DELETE and your table is buffered, issue TABLEUPDATE(.T.) the Thisforem.Refresh().

DELETE
=TABLEUPDATE(1,.T.,'mytable')
Thisform.Refresh()