2 Replies Latest reply on Dec 7, 2013 4:53 PM by OwlRidge

    making rules



      making rules


           I have two drop down boxes.  One with clients and the second with the project numbers (each client has multiple projects). 

           When I select a client in the first drop down I only want the project numbers for that client to be shown in the second drop down box.

           So if I select client apple then the second box would have app1, app2

           And if I select client orange then the second box would have org1 org2 org3

           Right now the second box shows app1, app2, org1, org2, org3

           I am using a trial version of filemaker 12 to decide if we should purchase the program


        • 1. Re: making rules

               You might want to download the FileMaker 13 trial to see the new features it has to offer (or wait a bit to "stretch" your evaluation period out another 30 days...) wink

               Brace yourself, massive "info dump truck" is backing up here...

               What you are describing is called a "conditional value list".

               There's a lot of overlap between the first two links so you can read one and skim the other. The demo file gives you several examples of different conditional value lists so you can examine them to see how they are set up. If you are using FileMaker 12, you can open this demo file from your File menu to get a converted copy of the demo file that you can examine in FileMaker 12.

               The last link discusses how to set up a chain of conditional value lists where the value selected in each conditional value list controls the values listed in the next value list.

               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.

               PS. and some time soon, I really ought to set up a tutorial/demo thread that uses ExecuteSQL for a conditional value list. There are options for that which do nice things that are difficult to pull off with the "traditional" methods...

          • 2. Re: making rules

                 Thank you that was very helpful.