Posted on 2006-05-21
Last Modified: 2013-12-18
Any additional ideas to complement sjef's idea in regards to the question above will be much appreciated.

Question by:varvoura
    1 Comment
    LVL 18

    Accepted Solution

    Ok, if it were my database, with certificates.  
    The main page is the main document.

    Each Certificate is a response document with your certificate # field, who created, date created and the parent unid as a field (which is also $Ref), and the sortdate field: yyyymmddhhmmss.

    The lookup view  contains the certificate document only.
                     -first column is the parent unid, sorted, categorized,
                     -second column, hidden, sorted, descending - sortdate.
                     -Third, etc. is whatever you want to display
                     -fourth is parsed column, date + @char(9) + who + @Char(9) + Whatever
    On the parent document, you can:
       1. Embed the view, and categorize by parent unid, or
       2. Do a lookup at the top of your form (parent document) in a computed for display field and return the fourth column, and put these results in a computed for display field on the form.

    When the user needs to enter a new certificate, they press the button, a dialog box opens (if you need to get information, otherwise, it just creates another certificate and refreshes the parent document so that it shows up in the view.)

    I'm not sure what all the comments where in the last question, much too long and counterproductive for my taste...:)

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
    I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    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

    20 Experts available now in Live!

    Get 1:1 Help Now