delete from view rather than from table. refs #3