12 Replies Latest reply on Jun 18, 2010 8:56 AM by philmodjunk

    sub-dropdown list

    ocolamonici

      Title

      sub-dropdown list

      Post

      I am trying to create a value list that is connected to other value lists so it can be displayed as sub-dropdowns.  For example, the first list has States and if you mouseover to Illinois a second list with cities in Illinois is displayed.  Is there a way to do this?

        • 1. Re: sub-dropdown list
          philmodjunk
            

          That would be a very nice feature request!

           

          Unfortunately, FMP can't do that out of the box. However, you can have two drop downs, one for your state and one for your cities. You can set this up so that when you select Illinois, the second menu is limited to cities from Illinois.

          • 2. Re: sub-dropdown list
            ocolamonici
               Thanks. I imagine that in your suggestion to limit the second menu to a specific list you do it with a script that selects the correct second list.
            • 3. Re: sub-dropdown list
              philmodjunk
                

              No script, just a relationship. There's an option you can select in your value list definition that limits values to the related values.

               

              Let's say you have a table of Cities with two text fields:

               

              CityName and State

               

              In a layout referencing the table where you want your two value lists, You define a field (could be a global field), for your state value list and link it to Cities::State.

               

              Now you can use this relationship as part of your value list definition.

              • 4. Re: sub-dropdown list
                ocolamonici
                   Thanks.  I will try that. It seem simple.
                • 5. Re: sub-dropdown list
                  dm
                    

                  I've tried following these instructions carefully, but must be missing something.

                   

                  I set up the two tables and connected via state:

                  Parent                  Cities

                  state--------------state

                  state                    City

                  City                      state

                   

                  On the layout for Cities I entered several records: Boulder, CO; Denver, CO; Omaha, NE; Chicago, IL

                  On the Parent layout the state is a drop down list showing CO, NE, IL.

                  On the Parent layout the City is a drop down list showing values from "City" in the Cities table.  ::City

                   

                  I tried creating a record in the Parent layout.  I chose CO as the state.  In the City drop down, ALL the cities show up, not just the ones restricted to CO.

                   

                  I'm sure I'm missing something.  Can someone guide me through this so that only the cities in CO show up when I select CO?

                   

                  Thanks

                  dm

                   

                  • 6. Re: sub-dropdown list
                    philmodjunk
                       Did you set this up with "Include only related values starting from: Parent"?
                    • 7. Re: sub-dropdown list
                      dm
                        

                      No I didn't.  I'm new at this and was unaware of that capability.  I did find some specific instructions through FileMaker 'Help' and am attempting to set it up so it includes only related field values.

                       

                      Thanks for your input.  You've pointed me in the right direction

                      dm

                      • 8. Re: sub-dropdown list
                        JimLandfield
                          

                        I am new to FileMaker Pro. Can someone tell the best way to get a whole bunch of questions answered?

                         

                        Like.

                        1. How do I make a dropdown menu of allowed possible answers?

                        2. How do I get new fields I add through the layout edit to recall automatically the information from other records but the same field? Kind of an automatic typing feature?

                         

                        Jim

                        JLandfield@financemgt.com

                         

                        • 9. Re: sub-dropdown list
                          davidanders
                            

                          Browse the Help Menu in Filemaker?

                          Buy a book about Filemaker? Missing Manual series is good, generally.

                          View the free lessons in the Filemaker videos at www.lynda.com

                          View the filemaker videos on youtube.com

                          http://www.google.com/search?q=filemaker+site%3Ayoutube.com

                          View the information on www.filemaker.com

                          http://www.filemaker.com/products/filemaker-pro/video_tutorials.html 

                          • 10. Re: sub-dropdown list
                            philmodjunk
                              

                            Here's a thread on setting up conditional value lists you may find helpful:

                            Custom Value List?

                            • 11. Re: sub-dropdown list
                              JoeDutch

                              Your workaround is nifty, but am I right in guessing that it only works with statically-defined values?

                              In my problem case, a text field "Author" offers a choice from a drop-down list of names which displays the values taken from the field contents in a related table ("Contacts::Name"). That list is getting long and requires a lot of cumbersome scrolling. Hence the need for a two-tier solution, with the names in the drop-down list categorized by initials. Ideally the drop-down list for "Author" should show 26 values (A-Z) in a primary drop-down list; the selected initial would then unfold into displaying the relevant names as selected by that initial. But as I say, the names are not a static, separately defined value list but a variable set of values taken from a related table....

                              • 12. Re: sub-dropdown list
                                philmodjunk

                                No, conditional value lists do not work with static or "custom" values. They specifically work with values drawn from a field in a table so they should work for you in this situation.