Notes/Domino 6 and 7 Forum : LScript: Delete documents using a Terminations List

Hi,

I have a database, with 2000 documents in a view based on one form - Mediflex. I have another view, called Terminations based on a form called originally, Terminations. This terminations view- has doctor names on it, and is the key to deleting information from the Mediflex view.

So if Doctor Edward Russell is listed in the Terminations view, he needs to be deleted in the MediFlex view.

I thought maybe the best way to do this, using script would be to use the Terminations documents as a KEY - in a FTIndex Search, and then delete. Here is my code:

'scan through terminations, and build a key
While Not (doc Is Nothing)
a=a + doc.FirstName(0) & " " & doc.LastName(0) & " OR "
Set doc = view.GetNextDocument(doc)
Wend

'create a documentcollection and search for the keyed documents and delete
Set dc = db.FTSearch(a, 4000)
Call dc.removeall(True)

This is all great, but I end up deleting them from the Terminations view (which is ok)- but nothing from the mediflex view. What am I doing wrong? Should I do this another way? Any help would be appreciated!

Thanks.