Display child links in parent form

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?
LVL 5
apparitionAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

qwaleteeCommented:
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
qwaleteeCommented:
(Use | @AllDescendants instead of | @AllChildren if there are multiple levels of children you wish to display.)
0
apparitionAuthor Commented:
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
Become a Microsoft Certified Solutions Expert

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

qwaleteeCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
apparitionAuthor Commented:
Getting a category not found error
0
qwaleteeCommented:
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
marefinCommented:
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
qwaleteeCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.