1 Reply Latest reply on May 14, 2014 6:17 AM by philmodjunk

    How to show value list according to field name



      How to show value list according to field name


           I used separtion model. I divied whole project in DB and UI. Now in UI I want to show value list acconding to field.E.g If I selected dessert than ,Ice creame cake etc value list have to show and If I select dinner than related to dinner item want to show. How to perform this ?FIles are hosted on server

        • 1. Re: How to show value list according to field name

               This is called a conditional value list. whether using the data separation method or a single file. It is set up the same way--You need a relationship between the two tables matching records by the field where you select dessert or dinner. That relationship would be set up in the interface file between two table occurrences of your tables in the data file.

               There are a number of options you can use to set up a conditional value list. Here are some links and a demo file on the topic:

               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 or later, you can open this demo file from your File menu to get a converted copy of the demo file that you can examine in your version of FileMaker.

               The next to 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 and the very last link is a fairly new addition that describes how to use ExecuteSQL to produce conditional value lists that aren't easily possible with the other methods described here.

               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

               Using ExecuteSQL to produce a conditional value list: Using ExecuteSQL to Produce a Conditional Value List

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