Show parents and responses in seperate view frames

Posted on 2009-04-30
Last Modified: 2013-12-18
I have this idea that I would like to have two views one showing response documents and one showing parent documents. These would be displayed in two frames on top of each other.

I would like to be able to click the parent document and see the children documents in the frame below.

My ideas were to try and use the onselect command on the view to pass the universalid as an environment reference between the views then update the selection formula.

Would this be easier with embedded views? What about the @SetViewInfo command?
Question by:RBCHARNLEY
    LVL 22

    Accepted Solution

    It would be better to use Embedded View for that purpose.
    The first column should have property "Show single category" selected.
    Parent child relationship is maintained through $Ref field in response documents (it holds UNID of its parent doc).

    From designer help:
    You can restrict an embedded view to a single category. However, for the Show Single Category option to work, the embedded view must first have been categorized . Note that the category name will not appear in the embedded view. For example, if you check the Show Single Category box for a category named Kitchen, the embedded view will not have a line named Kitchen. Instead, you will see under Kitchen documents such as Stove, Refrigerator, and so on.
    Also, if the Show Single Category formula evaluates to an asterisk (*), all categories are shown. This is useful if, for example, you want to restrict an embedded view to a single category for Web users and show all categories for Notes users.

      1.      Open a form in Designer.
      2.      Choose Create - Embedded Element - View.  The Insert Embedded View dialog box appears.
      3.      Highlight  the view you want and click OK.
      4.      Choose "Show Single Category" as the event in the object list in the Programmer's pane.
      5.      Enter a formula to compute the category. The formula can make use of information about the current user and information from the current document (the one embedding the view).

    Hope this helps,

    Author Comment

    Okay here it is

    You embed a view on a form (it dosen't work on a page) with the show single catergory formula
    The view embedded should be catergorised by a column containing (@Text($REF)) and contain all children documents you want to show.

    Create a second view that has in just the parent documents
    In the on select command of this view put

    And in the queryrecalc command

    And finally the query open command

    Create a frameset and split it into two rows. Make this the default frameset for the database.

    In the top row specify your view of the parent documents

    In the bottom row specify the form your embedded view is on

    Load your database. Now when  you click a document in the top it will refresh the view at the bottom and re-filter appropriatley.

    Thanks for your suggestions.


    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
    This is an old article, please see an updated version of this article, located here:
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now