Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Nested Pop-Up Lists

Posted on 2002-04-03
1
Medium Priority
?
350 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 400 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Online promotion is consistently becoming more important for all types of businesses. From Facebook ads to search engines to YouTube videos, there are all sorts of channels that can effectively be used to promote a business or product. But how shoul…
In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
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…

610 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