Is it possible to make the value list in a second pop-up list dependent on the value chosen in a first pop-up list?

For example, the first pop-up list offers a list of chapters, the second offers a list of subsections. If the user selects chapter 1, the second value list is populated with a list of subsections for chapter 1. If the user selects chapter 2 from the first list, the second value list is populated with a list of subsections from chapter 2.

Thanks

Scott

Hi Scott,

It is indeed possible. The most common way to set it up, assuming you are using FMP v5.0 or higher, is via a conditional value list.

To set it up, you will first require a relationship which matches the chapter field to a chapter field in the same or another file (which has subsections in another field).

Then set your value list to use values from the sub-sections field, but select the option for 'Only related values...', and specify your chapters relationship.

It will then work in the way you describe.

Thanks for your response, Ray.

I am a beginner with FileMaker. Do you know of an example that I could study?

Thanks

Scott

Hi,

As it happens, there is a demo file which shows a conventional conditional value list in operation, which is available for download from one of the demos pages of my website. The page in question is at:

http://www.nightwing.com.au/FileMaker/demos4.html

The file in question is the first one listed on the page (there are some other files that show alternative techniques fro doing similar sorts of things, but the first one uses the technique I described above.

Cobalt,

I was wondering if you have a sample regarding multit-selection from different drop down menu. i am trying to do a find base on what a user selected from different drop down menu and than click on button that would take the user to summary layout. you can view a picture of what i am trying to do at http://www.asmt.com/dblayout.gif. take a look at the yellow box with the different drop down menus

Hi,

I don't know what sample Ray could have here, but I would personaly use relationship instead of a classic find if all the 4 fields must be filled.

From the file you refer to

- create 4 global fields (gStatus, gLocation, gYear and gClass)

- create 2 calcs :

Status & "-" & Location & "-"& Year & "-" Class

gStatus & "-" & gLocation & "-"& gYear & "-" gClass

- Create a relationship with the "global" calc at left side and the "current" calc at right.

Script a go to related record + destination layout.

Any of the globals would use values from the current field in the file.

If not, there are a lot of posts on the subject, even in the near past, you may have a look to.