Jump to content

Conditional Value List?


Alisun
 Share

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

Recommended Posts

Hello, I'm not sure of the correct terminology... If I have a field with a value list called "Countries", and if I choose the United States, I would like the field beneath it to have a value list with the 50 states. However, If I choose the country Canada, I would like the field beneath it to have a value list with Canada's provences.

Is this called a conditional value list? If so, I can look through the FMP Forum archives to see if anyone has described how to set this up. Any help to point me in the right direction would be appreciated!

Thanks!

Alisun

Link to comment
Share on other sites

John,

Hope you dont mind but I added a couple of touches to your file. The Label will change if its a State or a Province and the drop down will reflect State or Provinces through an auto entered calc.

Dean

Link to comment
Share on other sites

Dean,

I tried to take a look at your file again, and I a message that the file is damagaed. I'm still trying to figure out how the conditional value lists are created...

How does Filemaker know when I choose "United States" that it should show the second menu with "Texas"? When I choose "Canada", how does Filemaker know to show the second menu with "Quebec"?

Thanks,

Alisun

Link to comment
Share on other sites

  • Newbies

Hi to All,

I have looked at your solutions to this post because I have a similar situation, but I cannot grasp the methodology in the examples. What I want is to have a value list in field-"Maker" and when a Maker selection is made it will autofill another field with a value list of that maker's products. My Maker value list would have about 8 or 9 values. I can't quite figure out what the 2 extra fields in your example are for since they both have the same calc and can't figure whyb there needs to be a Form View2? I would appreciate your help to understand this better.

Thanks heaps,

Brian

Link to comment
Share on other sites

I'm having the same trouble - I know what a conditional value list looks like, but don't know where to begin to create one! The FileMaker Help section has great step-by-step instructions for most functions, but nothing for "conditional value list".

Link to comment
Share on other sites

[color:blue]Conditional Value Lists, aka [color:blue]Dynamic Value List examples can be found in the Sampole File Topic, and as help files in the Value List Topic Area.

There are also several sites that have example files that maybe of help you.

John Mark Osborne's site

http://www.databasepros.com/

and

www.fmfiles.com

come to mind

Once you have had a chance to see how they are done, and if you still have questions, then post an example of what you are want for your lists .

HTH

Link to comment
Share on other sites

Thank you very much for letting me know that they are also called "dynamic" value lists.

I found a step-by-step example on Filemaker's site, and (hooray!) was able to create a dynamic value list! For any newbies like me who want to see the example:

http://filemaker.custhelp.com/cgi-bin/filemaker.cfg/php/enduser/std_adp.php?p_faqid=5833

Alisun :cloud:

Link to comment
Share on other sites

This topic is 5673 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.