>The main issue here is that I use the view to update the respective tables. So everytime I mark a record for deletion on the view, it updates it on the tables. But when I run the view again, the records come as unmarked on the view, but still marked on the tables. How do one make the view know and show that the record is marked for deletion on the table. Using SET DELETE ON/OFF specifies whether Visual FoxPro processes records marked for deletion and whether they are available for use in other commands.

If records are marked as deleted in the source data for the view, and SET DELETED ON. If you close and/or in any way refresh that view, those records should not show up in the view records.

However, you have to make sure the view is in fact completely refreshed. You can test this by opening the view in the development environment. Delete some records and do a tableupdate().
Then close VFP. Restart VFP and open the view with SET DELETED ON and see if the view now reflects only records NOT marked for deletion. If not, then you are not updating the source table correctly or your SQL for the view has some problem. You can also try experimenting with refresh(), the function, not the method.