Solved

Display child links in parent form

Posted on 2003-11-18
8
323 Views
Last Modified: 2013-12-18
I have a form that has responses. When the user views the
parent document from a view I want them to see links to all
the response documents that belong to the parent. how can this be done?
0
Comment
Question by:apparition
  • 5
  • 2
8 Comments
 
LVL 31

Expert Comment

by:qwaletee
Comment Utility
Set up the view s it displays response hierarchy (a view property), add a column of type "response column," and add | @AllChildren to the view selection.
0
 
LVL 31

Expert Comment

by:qwaletee
Comment Utility
(Use | @AllDescendants instead of | @AllChildren if there are multiple levels of children you wish to display.)
0
 
LVL 5

Author Comment

by:apparition
Comment Utility
I can already see the document hierachy in the view. I want to see
the child links when the user actually clicks to view the document.
0
 
LVL 31

Accepted Solution

by:
qwaletee earned 35 total points
Comment Utility
Now, reading your question, it is a little unclear whether you meant you wanted to display all the chidren in the view, or if tyou wanted links on the parent form itself.  (The confusing thing is you mention "parent form" in the title, but start with "views the parent document from the view").

To show al immediate children directly on theform:

1) Build a hidden view named (ByParent)

2) make the view NOT show response hierarchy

3) Column 1 is categorized, formula @Text($Ref)

4) Save the new view

5) Open the parent form in designer

6) Choose Create -> Embedded Element -> View

7) Select the new view, click OK

8) In the code pane at the bottom, click on the Show Single Category section for the embedded view

9) Type formula @Text(@DocumentUniqueID)
0
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

 
LVL 5

Author Comment

by:apparition
Comment Utility
Getting a category not found error
0
 
LVL 31

Expert Comment

by:qwaletee
Comment Utility
That woudl occur for any parents that have no children (is that an oxymoron?).  To get around this, we'll code a check to see if there are any documents with the crrect key.  if there are none, display no view.  If there are any, display the view.

NB: Step 3a should have been "add at least a second column to teh new view; this will be what displays to the user for each child, on the parent form."

Change the view from a fixed name to a formula.  the formula should be:
check := @DbLookup("":"NoCache"; ""; "(ByParent)"; @Text(@DocumentUniqueID); 1);
@If(@IsError(check); NOTHING_TO_DISPLAY; "(ByParent)")

Note: the above formula is to calculate which view is selected.  The formula from the earlier post is for which category to display.  View select and Show single category are separate things.
0
 

Expert Comment

by:marefin
Comment Utility
I think I know why this might be happening......the children are not realy children
they are just older versions of the form would this have something to do with it?
0
 
LVL 31

Expert Comment

by:qwaletee
Comment Utility
Yes, it would.  You need to have some sort of key value tieing the documents together, categorize on that key, and use that key as the show-single-category.  In th case of parent/child, the key is tehparent unique ID, which is obtainable atthe parent as @Text(@DocumentUniqueID) - hence teh single category... and in teh children as @Text($Ref), hence the view categorized column.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

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.
This video discusses moving either the default database or any database to a new volume.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

763 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

9 Experts available now in Live!

Get 1:1 Help Now