Solved

Trying to create a view for response docs only.

Posted on 2000-03-06
2
182 Views
Last Modified: 2013-12-18
Hi I have two forms with one form used as a response to the other... one parent and the other a child form... When I create a view with a selection formula with only the child doc no documents are selected...
ie Selection (Form = "child")
I have to do the following to select the documents
selection ((Form = "parent")|(Form="Child))
But this creates a row for the parent doc then follows with all of it's repsonses then the next parent doc and so on

Is there a way I can create a view to show all the response docs without selecting the coresponding parent docs?
0
Comment
Question by:sbaek
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 6

Accepted Solution

by:
ghassan99 earned 50 total points
ID: 2589204
Use this in the selection formula:
SELECT Form="form_name" & @IsResponseDoc
Also remember to disable the option "show response documents in hierarchy" in the view's properties, which is a common mistake.

-Gus
0
 
LVL 6

Expert Comment

by:ghassan99
ID: 2589209
I noticed you mentioned all response docs, then you can omit the form's name from the selection like this:
SELECT @IsResponseDoc

-Gus
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question