Is the New_Entry form used only for response doucments or can it be used for a parent document?

I think using @AllChildren is redundant as @AllDescendants would include both immediate Responses and Responses to Responses.

Assuming the New_Entry form is for responses only, try this:  SELECT Form!= "NEW_Entry" | Form = "NEW_Cad" | @AllDescendants

... but I don't think it's possible to exclude responses based on a formula when using @AllDescendants and @AllChildren

Thank you Paul for your quick reply

Form = "NEW_Cad" is the parent document and Form="NEW_Entry" could be response or response to response.

I tried your recommended formula but unfortunately I still can see documents created with Form="NEW_Entry" in the view. Is there a solution for this issue?

Thank you Paul for your quick reply

Form = "NEW_Cad" is the parent document and Form="NEW_Entry" could be response or response to response.

I tried your recommended formula but unfortunately I still can see documents created with Form="NEW_Entry" in the view

Hi,

you can Remove (@AllDescendants & @AllChildren) and specify the form names.

Form ="New_CAD" | Form="Another_CAD" ..... and so on and don't mention "New_Entry".

the parent child relationship will remain even if you don't specify the @allchildren. And I presume what I have suggested is better for performance.

Hope this helps

Thank you Samer so much. It is working now. This is s good solution