Solved

Nested Pop-Up Lists

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

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

Suggested Solutions

The most recent Google Panda algorithm update that I wrote about was Panda 2.5 (http://www.experts-exchange.com/Web_Development/Internet_Marketing/A_8112-Google-s-Panda-Algorithm-Update-Panda2-5.html), and there have been several iterations of the P…
This story has been written with permission from the scammed victim, a valued client of mine – identity protected by request.
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…
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…

920 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

14 Experts available now in Live!

Get 1:1 Help Now