Solved

How to display values under each category?

Posted on 2001-07-03
4
207 Views
Last Modified: 2013-12-18
I created an editable keyword field(v1) which contains these values : Dell,Ibm,Toshiba. I also created 2 editable keyword fields(v2,v3).For v1 field, it will display the values when a value is selected from v1 e.g when Dell is chosen, v2 field will display PowerEdge,Optiplex and Dimension only. For v3 field, it will display values when a value is selected from v2 e.g when Optiplex is chosen, v3 field will display GN+,GX1,GX110. If Ibm is chosen in v1 field, v2 field will display ThinkPad,Aptiva,Server only and will not display PowerEdge,Optiplex and Dimension. If ThinkPad is chosen in v2 field, v3 field will display 560E,560X,240X and will not display GN+,GX1,GX110. This situation will be the same for Toshiba.

Thus, How do I display the values for v1,v2,v3?
Pls help.Thanks
0
Comment
Question by:kopibean
  • 2
4 Comments
 
LVL 4

Accepted Solution

by:
sloeber earned 20 total points
ID: 6251569
The best way to do this is dynamically.
Make a new form, with three fields v1,v2 and v3, and call the form Keywords, or something like that.
Now you make a new view, with the first column the value v1 and categorized, and in the second column the value v2 and sorting ascending.
So, the last thing you must do is make another view.
Where the first column is categorized and has as value v1 + v2
The second column has as value v3.

In your main form you set your first field
@DbColumn("":NoCache";"";"ViewName";1)
Your second field v2, will have the value
Selection :=@Dblookup("":"NoCache";"";"ViewName";v1;);
@If(@IsError(Selection);"";Selection);
Your third field will have as value
Selection :=@Dblookup("":"NoCache";"";"TheOtherViewName";v1+v2;2);
@If(@IsError(Selection);"";Selection);

Greets,
Sloeber
0
 
LVL 13

Expert Comment

by:CRAK
ID: 6251626
First you'll need to define your keywords somewhere to define what options the 2nd and 3rd keywordsfield should show for the in the 1st keywordsfield selected option. A parent/response/r2r structure could be userful.

Second you'll have to build a view in which you can lookup all entries for v2 by the key in v1, and a view to lookup options for v3 based on v1+v2.

Third, on the form I would use two additional (hidden) fields: Lst2 and Lst3, providing the options for v2 resp. v3.
Refresh all fields on keywordschange in v1 and v2. Recompute (@DbLookup) Lst2 and Lst3 on refresh and use a translation formula in v2 and v3 to clear it if their content is no longer offered in kwd2 resp kwd3 (that's why I used the additional fields: If I didn't I could either end up with values not belonging together if I changed v2 again after v3, or I would have to perform two more @DbLookup's, slowing things down).

The v1 list of choises is fed by a @DbColumn on view1, column 1.
Kwd2 if fed from the same view, column 2 using @DbLookup (key = v1).
The v2 list of choises is fed from Kwd2.
Kwd3 if fed from view2, column 2 using @DbLookup (key = v1 + v2).
The v3 list of choises is fed from Kwd3.

(I hope that was all clear!?)
0
 
LVL 13

Expert Comment

by:CRAK
ID: 6251633
Sorry, that anwser is pretty much the same as sloeber's. It took me a while to write/post it....
0
 
LVL 10

Expert Comment

by:zvonko
ID: 6253204
Has this to work in NotesClinet or Web?
Because I have another idea...
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

910 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

16 Experts available now in Live!

Get 1:1 Help Now