Solved

Nested Pop-Up Lists

Posted on 2002-04-03
1
306 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
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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

For many of us, the  holiday season kindles the natural urge to give back to our friends, family members and communities. While it's easy for friends to notice the impact of such deeds, understanding the contributions of businesses and enterprises i…
A great marketing strategy is diverse.  Read about the not so popular, yet effective, marketing tactics you can start using today!
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 choose which pages of your form are visible to your users based on their inputs. The page rules feature provides you with an opportunity to create if:then statements for y…

803 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