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
Solved

Display list of countries under correct group

Posted on 2004-08-12
2
205 Views
Last Modified: 2013-12-18
I have a view called Company which contains

GROUP             Company
--------             -----------
HP                   Singapore, Malaysia, Thailand, Italy
MOTOROLA      Penang, Kuala Lumpur, Ipoh
Philips              Cambodia, Taiwan

When user go to another view and click to enter a new document,
Under one section :

Customer     Group  field A(editable dialog list which get the values from view Company
                                        column 1)
                   Region field B(editable dialog list to display values based on field A to let    
                                        user select which coompany to display)
                              button field C (display all companies depend on value in field A)

e.g when user select HP in field A, it should display all the companies which are Singapore, Malaysia, Thailand, Italy in field B.
when user select Philips in field A, it should display all the companies in field B.

How to I code my field B to work as the example above and the button field C to display all the companies depend on the value which user select in field A?

0
Comment
Question by:kopibean
2 Comments
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 11781484
Set the first dialog field to
    Refresh form when field is changed
and all other dialog fields to
    Refresh form when field is changed
    Refresh options when form is refreshed
0
 
LVL 31

Accepted Solution

by:
qwaletee earned 30 total points
ID: 11785419
Do what Sjef says... in case you were also asking how to set up teh fields so they have those choices in the first place, here's how:

I will assume the first field is named GROUP and the second field is named REGION
Fields should both be Dialog List fields
Go to properties for GROUP
Go to second tab
The drop down in the "Choices" section should say "use formula for choices"
Formula should be @DBColumn(""; ""; "Company"; 1)
Go to the second tab of properties for REGION
Drop down should also say Use formula for choices
Formula should be:
queryResult := @If(!@Trim(Group)=""; @DbLookup(""; ""; "Company"; GROUP; 2); "");
@If(@IsError(queryResult); "Error - " + @Text(queryResult); queryResult)

Make sure that the Company view sorts on the group field, that the first column has group, and the second column has region.

0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Domino not switching to TLS 1.0 4 801
how to install domino server on suse linux 18 89
Lotus Notes shared mailbox 'Sent by' in header 3 96
problem with deleted user 14 28
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.
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

839 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