?
Solved

Viewing only certain forms

Posted on 2003-03-25
4
Medium Priority
?
207 Views
Last Modified: 2013-12-18
Hi. I am a rather novice designer developer and am having what appears to be a simple issue, yet I cannot figure it out.  I have two forms in my new "test" database: "project" form and a "status" form (a response docuemnt to the project form). I want to create a view "status by Date" which only shows selected fields from the status document, so for the view property, I used Select Form = "Status".  I then created just one column to show the title and one column to show the date field from the form...However I get nothing in the view, although I know there are two such documents created.  If i do Select @all...I get everything (both the project and status form fields) in the designer view, but only the "project" entries in the actual Notes view...however, I only want the fields from the "status" form in the view, not both and not just project.  Why am I getting nothing and how can I accomplish this?
Thanks.
0
Comment
Question by:lauren4110
[X]
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
  • 3
4 Comments
 
LVL 7

Expert Comment

by:scottrma
ID: 8204586
Comparisons are case sensitive.
0
 
LVL 7

Expert Comment

by:scottrma
ID: 8204591
Try this instead:

SELECT @LowerCase(Form) = "status"

Regards,

Scott
0
 
LVL 7

Accepted Solution

by:
scottrma earned 200 total points
ID: 8204598
Also, make sure to disable the view property "Show response documents in a hierarchy".

Regards,

Scott
0
 

Author Comment

by:lauren4110
ID: 8204706
THanks! That worked!
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
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
Course of the Month9 days, 9 hours left to enroll

762 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