dear all,

i have a questions about making a dropdown menu, for example:

i have a category Food

the sub category : frozen food, fruits,snacks

if i have some categories, food, beverage, tobacco, etc, and i choose food in a dropdown list, it will jump directly to the next field (sub Category)

how can we make the script? thank you

Hi Budi and welcome to the FM Forums,

What you are describing is a conditional value lists. Here is a link to FIleMaker Help

 http://help.filemaker.com/app/answers/detail/a_id/5833/~/creating-conditional-value-lists

There are examples of Conditional Value Lists in many places and threads, this question comes up often,  

here is a video by Martha Zink that walks you through it. 

https://www.youtube.com/watch?v=2C62NlAR8vY 

Let us know if you still need help on this question.

Lee

I made two examples files based on the links, the first one is following the FileMake help and the second one is following the Soliant video.

ConditionalValueList.fmp12

Soliant- Conditional Value List.fmp12

great, thank you somuch lee

 

On 5/8/2016 at 7:42 AM, Lee Smith said:

Hi Budi and welcome to the FM Forums,

What you are describing is a conditional value lists. Here is a link to FIleMaker Help

 http://help.filemaker.com/app/answers/detail/a_id/5833/~/creating-conditional-value-lists

There are examples of Conditional Value Lists in many places and threads, this question comes up often,  

here is a video by Martha Zink that walks you through it. 

https://www.youtube.com/watch?v=2C62NlAR8vY 

Let us know if you still need help on this question.

Lee

I made two examples files based on the links, the first one is following the FileMake help and the second one is following the Soliant video.

ConditionalValueList.fmp12

Soliant- Conditional Value List.fmp12

following this guide I attempted to create a DB with one more subsumed level [ideally I'd like 2 subsumptions], as I'm attempting to create a DB with Tests/TestName/TestResult/TestResultText

The value list condition I set was 

        Table3:LevelThreeItem

        Include items related from 2nd table (labeled Items in your example).

In Layout mode I have tried using Table1(list) and Table2(aka Item) list

and do not get the third level option to show (says missing values, although I created values for Table3 )

So obviously I didn't understand the concept well enough

1) Is my value list wrong?

2) is the relationship wrong?

3) is the field designation on the layout wrong?

Any guidance would be appreciated.

ConditionalValueListLevelThree.fmp12