Jump to content

Category and sub category


Budi Hananto Seto
 Share

This topic is 1511 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 2 years later...
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

Link to comment
Share on other sites

This topic is 1511 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.