3 Replies Latest reply on Feb 4, 2013 12:36 PM by philmodjunk

    Value Lists

    GregLaBelle

      Title

      Value Lists

      Post

           Hello, I am new to Filemaker...so i am learning about the program...i have worked with access and understand it...

           My question is How to get different values list from the same table based on certin criteria.

           this is what i have

           Table 1 is clasification it has   Classificationd_ID , and Clasification...

           Table 2 is Lifts it has Lift_ID, Lifts, Classification_ID

           Now on my layout for the work out i have 6 different drop downs to input different ifts

           1. explosive lift

           2. Knee/hip

           and so on..these never change. how can i get the proper lifts into each value list based on the classification. Ex. lift 1 is all ways explosive, lift two is allways knee/hip..

           I no how to do this in access but just can't get it right here..I have read alot about value list but seem to be missing point

            

           Thanks in advanced

        • 1. Re: Value Lists
          philmodjunk
               

                    i have worked with access and understand it

               Sometimes that can add to the challenges of getting FileMaker to work. A SQL based approach often is not possible in FileMaker, so you mentally reach for that familiar tool only to discover that you have to use a very different approach to get the same results in FileMaker.

               What you describe, we call a "Conditional Value List". Here are some links to help you get up to speed in how to set these up in a FileMaker Database system:

               Forum Tutorial: Custom Value List?

               Knowledgebase article: http://help.filemaker.com/app/answers/detail/a_id/5833/kw/conditional%20value%20list

               Demo File: https://www.dropbox.com/s/j6qf0z9fnem3uxd/ConditionalValueListDemo.fp7

               Hierarchical Conditional Value lists: Conditional Value List Question

               Feel free to post follow up questions here if those links aren't enough to get your value lists working correctly.

          • 2. Re: Value Lists
            GregLaBelle

                 OK thanks I think i have that one down.

                 What i'm really trying to do is get multiple value list from one table..

                 Explosive list

                 Knee/hip list etc based on one table and layout which inputs the information

                 Here is the table i have..I have pull down menus set up to enter lifts 

                 Lift one is all ways explosive, lift 2 is all way Knee/hip and so on.

                 Now my finished table will have hundreds of different lifts as they are added or taken out.

                 How would i go about making a value list for each classification ( there are 15 different ones) I don't want 15 different tables

                 thanks for the previous help

                  

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
                                

                                     Classification_ID

                           
                                

                                     Classification

                           
                                

                                     Lift

                           
                                

                                     1

                           
                                

                                     Explosive

                           
                                

                                     Power clean

                           
                                

                                     1

                           
                                

                                     Explosive

                           
                                

                                     Hang clean

                           
                                

                                     1

                           
                                

                                     Explosive

                           
                                

                                     Power Snatch

                           
                                

                                     2

                           
                                

                                     Knee/Hip

                           
                                

                                     Squat

                           
                                

                                     2

                           
                                

                                     Knee/Hip

                           
                                

                                     Front Squat

                           
                                

                                     3

                           
                                

                                     Horizontal Push

                           
                                

                                     Bench Press

                           
                                

                                     3

                           
                                

                                     Horizontal Push

                           
                                

                                     Incline Press

                           

                  

            • 3. Re: Value Lists
              philmodjunk

                   It depends on how you specify the lift category.

                   With a conditional value list, you can select "explosive, Knee/Hip, Horizontal Push..." from one field and then the conditional value list in the next field lists just the values that are a member of that category. You can define as many categories for your lifts as you want all in this one table.

                   If you are defiing multiple fields for this in one record--not something I would do in Access or FileMaker, I suggest setting up a portal to a related table to make the resulting data something that is much easier to work with.