Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Embedded View from a response to response form

Posted on 2004-03-23
Medium Priority
Last Modified: 2013-12-18
Hi! I have created 3 forms
    form1      Document  -- works fine
    form2      Response  -- inherits form1num from form1
                                  -- computes for form2num
    form3      R to R       --  a hotspot button (from form2) that gives me this form3
                                  --  this has a view called RR_VIEW
    RR_View is then embedded to the form2.
    The problem is that the embedded view in form2 is empty, but if I view it from view it does have values in it.
    RR_View Select form="form3"
    Embedded view = f3embedview
    SS Category      = form2num (my view has form2num on the left and is categorized)
I guess I have all the info. Thank you.

Question by:cyle
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
  • 2
LVL 13

Expert Comment

ID: 10661469
Since RR_View only selects "Form = form3", first check if the view is hierarchical (in view properties)... it should NOT be since the parent documents (form1) are not included.
Check if the category in RR_View is ok e.g a reference to a field on form1, or @Text($Ref)
Check if the single category formula in the embedded view is ok with this category. Bear in mind that additional spaces may mess things up, that things are case sensitive and type specific (looking for "123" as text in a view that only has 123 as number in a category may not work (never tried it, but it won't work in @DbLookup... I don't expect it to work here either)

Author Comment

ID: 10661608
1. No, not hierarchical, only have Allow customization (this fine?)
2. The category in RR_View is form2num
3. The embedded view also has form2num as single category
4. I will not be typing any text since everytime I add data to form3 the embedded view should have that information based on form3num.

Author Comment

ID: 10661653
FYI, when I remove the Single category I can display info but the problem is all of i is displayed.
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

LVL 24

Expert Comment

ID: 10661968
Is the category a numeric field.. if so try the category of the column converted to text py placing @Text around the field value


Author Comment

ID: 10661991
I got it and the problem was I removed heading from the view. Thanks for helping.

Author Comment

ID: 10662010
What's the policy or what do I do if the answer was different from given and yet I still want to give some of the points to the expert?
LVL 13

Assisted Solution

CRAK earned 150 total points
ID: 10665574
You can only award all points yourself. Either to one expert or split amongst a few.
For special requests, you could post a link to this question to community support. Haven't seen a request to reduce points before though.... If neccessary (shouldn't IMHO), deleting or PAQ+refund could be an option: you could consequently post a "Points for...".

Are you sure it was the heading that caused the problem? It should work with AND without them!
LVL 24

Accepted Solution

HemanthaKumar earned 150 total points
ID: 10668227
You can split the points among experts !

Author Comment

ID: 10669174

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

705 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