if you want to remove the main doc which don’t have any child matching voltage1=6000, then you have to have a field in the main doc, I believe.
I don’t know any way to select a document based on the value from one of its children field.
You can set the parent field value with the PostSave event of the children for instance put all the possible values of voltage1 from the children in the field.
if the field in the parent doc is Voltage1List :
Sub Postsave(Source As Notesuidocument)
Dim db As notesdatabase
Dim parent As NotesDocument
Dim v As Variant
Set db = source.Document.ParentDatabase
Set parent = db.GetDocumentByUNID(Cstr(Source.Document.ParentDocumentUNID))
Set field = parent.GetFirstItem(”Voltage1List”)
v = parent.Voltage1List
i = Ubound(v) +1
Redim Preserve v(i + Ubound(source.Document.GetItemValue(”Voltage1″)))
Forall values In source.Document.GetItemValue(”Voltage1″)
v(i) = values
i = i + 1
parent.Voltage1List = Fulltrim(Arrayunique(v))
continue = True
The view formula is then “SELECT Form=Main & @contains(Voltage1List;”6000″)”
or “SELECT (Form=Main & @contains(Voltage1List;”6000″)) | voltage1=”6000″” if you wish to restrcit the children displayed to the ones that match voltage1=”6000″ or … if …
if your application is to be used through web, you could do it the other way around.
you make the responses doc inherit some fields from the parent’s doc.
in your view you select only the response doc making sure to categorize them by the inherited field and alter the column to display a link to the main doc.
This way you can open the main document. I can’t imagine a way to have the same behaviour in Notes. XPages maybe.