Deleting a Document ends up corrupting the View
Posted on 2003-03-17
I have a view which lists all the documents and the responses in a hierarchical format. The selection formula I use is
SELECT (form = "My Plan" ) | @AllDescendants
I can create documents and adds responses correctly and they show up in the view as expected.
I can even go ahead and delete responses and the view gets updated accordingly.
However, If I delete a document, I get a Notes prompt "Document Deleted" and I exit and re-enter the database and try to open the view, it displays another unrelated view (View B).
In the designer mode, I can see all the views correctly, but If I try to preview it in notes.. It displays the unrelated View (View B.
I am really confused. I then have to recreate the lost view from scratch, but I can reproduce it every single time. And I am not sure what the problem is and more importantly how to solve it.
I imagine it has something to do with document-responses relationship..but I am not exactly sure what or why or how?
Gurus, any help here would be greatly appreciated.