Solved

Nested Pop-Up Lists

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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
Filemaker 14 will not connect to remote database 4 84
Craigslist Software for Windows Computer 9 102
how Adwords bidding happens 1 74
Are online paid surveys a scam ? 2 62
With a software solution, you always get to control email signatures and have the final say on the design - not an unrelated department or the uninterested end user.
Digital marketing agencies have encountered both the opportunities and difficulties that emerge from working with a wide-ranging organizations.
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…

685 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