Domino Code Fragment

Code Name*
Doclinking Parent to Child A Notes formula for doc-linking a parent to a child in Notes R3/4		Date*
12/21/2025		Source (or email address if you prefer)*
[email protected]
IP address:.172.69.17.99
Description*
Doclinking Parent to Child A Notes formula for doc-linking a parent to a child in Notes R3/4		Type*
LotusScript		Categories*
(Misc)
Implementation:
Required Client:
Server:
Limitations:
Comments:
Files/Graphics attachments (if applicable): Code:
----------------------------------------------------------------------------
FILE:    Linking a Parent to a Response
UPDATED: June 1996
AUTHOR:  Eric Koeler
        mailto:[email protected]
        http://www.panix.com/~ekoeler
NOTE:    Copyright (C) 1997 by Eric Koeler, this file is protected by the
        GNU General Public License
----------------------------------------------------------------------------

Since every response document contains a field called $ref with its
parent's Doc ID in it, you can set up a hidden view of response
documents (No Response Hierarchy) with @Text($ref) as the first sorted
column's formula - we'll call this view (ResponseLookupView) and this
first sorted column Key.  We can use this $ref field as a common
unique lookup key.  Create a computed text field in the response
document, call it myID, with @DocumentUniqueID as the formula.  Now
create a computed text or a computed for display field in the parent
document, we'll call it respLink, with the following formula:

     @DbLookup("";"";"(ResponseLookupView)";
    @Text(@DocumentUniqueID);"myID")

This respLink field will yield a doclink to the response document.