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.