>How do you make a view recognise deleted records from the respective tables. When I use DELETE() function to check for deleted records on a view, it does not show. But the records are really marked for deletion in the tables. please help.

Check the SET DELETED command.