Solved

Nested Pop-Up Lists

Posted on 2002-04-03
1
320 Views
Last Modified: 2013-11-28
I need to create two fields, both set as pop-up lists, where the options in the second field are determined
by the selection made in the first field.

For example, the first field would contain "Colors, Foods, Animals" as choices.  If "Colors" is chosen,
then the second field would contain "Red, Blue, Orange" as choices, but if "Animals" was chosen in the
first field then the second field choices would automatically set to "Dog, Cat, Elephant."

Is this possible?  I heard that it could be done by a nested "IF" calculation, but I'm sort of at a
loss as to how to get started............
0
Comment
Question by:KentFerrell
[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
1 Comment
 

Accepted Solution

by:
asburgoyne earned 100 total points
ID: 7215854
1) Create a file with one field called "Topic".
2) Create a file with two fields: one called "Topic" and another called "Option".
3) Set a relationship from file 1 to file 2.
4) Create a screen with a portal so that you can create / amend / delete records in file 1 and file 2.

As per your example, you would create a record in file 1 with a value of "Colors".  You could then add the "Red", "Blue" and "Orange" entries via the portal which would create them as related records in file 2.  Now repeat the entry process with each of your topic and option combinations until you have whatever you need.

In your main database entry screen you would have two drop-down list fields.  The first would allow selection from records in file 1 and store the value in a field opic (lets call it "FieldX") in your main database.  The second drop-down list would allow selection from records in file 2 filtered on "FieldX".

This might sound a little complex but once you have done this once you will see how simple it actually is.  If you want to simplify things a little then you can replace file 1 with a fixed value list but I would only suggest that approach if you will not need to modify your topic list very often.

Adam
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

This story has been written with permission from the scammed victim, a valued client of mine – identity protected by request.
Read about why website design really matters in today's demanding market.
An overview of how to create reports in Adobe Analytics (formerly Omniture Site Catalyst) using pageNames, events, eVars and props. This video will show you how to install the Omniture Debugger tool so can see (and test) what is being passed int…
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to selectively show certain fields based on user input using rules to gather relevant information and data from your forms. The rules feature provides you with an opportunity…

691 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