2 Replies Latest reply on May 6, 2015 6:40 AM by ErnaMeierdierks

    Narrowing down a value list

    PaulStrasser

      Title

      Narrowing down a value list

      Post

      Hi all,

      I am doing a car dealership database for a school project. 

      When entering the details of a new car into the system, i wish to be able to narrow down the amount of models, when i have entered the make.

      For example, if i enter in that the car is a Toyota, is there a way to automatically make it only show a drop down list with Corolla, Ascent, RAV4, Prius, Camry etc. (i.e. all the models of Toyota). 

      Can someone please explain to me how to do this?

      Thanks very much

        • 1. Re: Narrowing down a value list
          philmodjunk

          This is called a conditional value list.

          Download this free file: "Adventures in FileMaking #1 - Conditional Value Lists". In it, you'll find 10 different ways to set up a conditional value list. The "basic conditional value list" example should be exactly what you need here.

          • 2. Re: Narrowing down a value list
            ErnaMeierdierks

            You might want to try this for a very Basic conditional Value List:

            You should have 3 Tables:

                   
            • Table A is your Data entry form which has the fields Brand and Model at least
            •      
            • Table B   "Brand" for all the Brands
            •      
            • Table C "Models" for  Brands and Models

            Then your are linking Table A with Table C thru the "Brand" field:

            Next you generate two value lists:

                   
            • One value list based on the Brands table
            •      
            • One value list based on the "Models" table, showing the Model-field of this table and you click "showing only values starting with "Data entry form"

            The "Brands" Value list you can also use for entering  for Model-Data - this ensures, that you don't enter wrong Brands or spelling on Brands.

            Now you define in your data entry form the Brand value list on your brand data field and your Model value list on your Model data field

            Next things to do: Add IDs to your tables, so that changes in Brand names and Model names will be automatically reflected in your data entry form (some more linkage and definition is required)