2 Replies Latest reply on Apr 11, 2017 3:11 PM by askewd

    Making a value list smaller


      Hey guys. Firstly i better warn you that i'm a newbie. :-)   this is my first post and not even sure if i'm in right place.   So bare with me :-)


      I have built a music database using Filemaker 15. My needs are quite specific but i'm going to simplify it here to get the crux of the question across clear as possible (hopefully haha). 


      ok - each record has quite a few fields but some of the main fields are as follows:







      I have the need to allow songs names to be selected from a pop up value list.   So for example i click on a field and from that field it pops up a list of song names of which i then select the one i need to be entered into that field.


      I have it working great at the moment.  However as the song list starts getting longer and longer i am realising i need to think about shortening the list, to only show relevant songs. 


      So how would I, for example,  ONLY show (in a pop up value list)  the songs which are at 100 BPM?      Or   ONLY the songs which are also by the same artist as the one i'm currently viewing?    (the latter being closest to my actual need).    In a nutshell,  to filter the list.


      I appreciate any help getting my head around how to achieve this


      Thank you


        • 1. Re: Making a value list smaller

          What you are describing is called a "conditional value list" (CVL) where the value in one field controls what values appear in the value list of another field. There are actually quite a number of different ways to do that in FileMaker. The most common method that you'll find under the "Conditional Value List" label uses a relationship to control which values appear in the value list. Other methods give you a filtered list to pick from, but don't use a value list at all to produce that list.


          Here are some instructional files on the topic. Each file has multiple working examples and each example has detailed documentation on how to set them up and how they work. Plus, you can ask questions about them here in the forum if you need to.


          Adventures in FileMaking #1--conditional value lists

          Adventures in FileMaking #2--enhanced value selection


          And please read the "Geek Busking" info on the first Intro layout...

          2 of 2 people found this helpful
          • 2. Re: Making a value list smaller

            Thanks Philmodjunk!  I'll go through those tomorrow and hopefully get my head around it :-)