Jump to content

3 conditional Value Lists


toddgm70
 Share

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

Recommended Posts

  • Newbies

I am new to Filemaker Pro and found your site extremely useful for making a conditional drop down menu. My question is :) How do i make three conditional drop down menus. For example, in the first category, I choose a type of food (meat, vegitable) if i choose meat, my choices are (fish, beef, chicken, pork) if i choose beef, the third drop down will be populated with a host of dishes with meat as its primary ingredient (peppercorn steak, beef bourgninon, BBQ beef ribs, etc).

I have tried doing this but i get into trouble with the third choice, as there are now 2 qualifiers.

I have searched the net for a guide to this, but i havent found one.

Thanks so much,

Todd

Edit: I have added my partially constructed database

Operative_Log.zip

Edited by Guest
Link to comment
Share on other sites

Example:

Two Tables, one for options, one for selection, three fields in each.

Option Table:

Field1

Field2

Field3

Selection Table:

DropDown1

DropDown2

DropDown3

Value List 1 comes from Field1

Value List 2 comes from Field2 over relationship starting from Selectiontable:

OptionTable-SelectionTable

Field1=DropDown1

Value List 3 comes from Field3 over relationship starting from Selectiontable2:

OptionTable-SelectionTable2

Field1=DropDown1

Field2=DropDown2

Hope this helped

~Genx

Link to comment
Share on other sites

  • Newbies

Im sorry to bother you, but i really am having problems setting up relationships....I know that your explaination is foolproof, but when it comes to databases, i am quite a fool!

I dont really understand what you mean by:

Value List 2 comes from Field2 over relationship starting from Selectiontable:

OptionTable-SelectionTable

Field1=DropDown1

Value List 3 comes from Field3 over relationship starting from Selectiontable2:

OptionTable-SelectionTable2

Field1=DropDown1

Field2=DropDown2

How do i imput this information? I cant seem to find where in Value Lists i can do that?

thanks again for all the help

Todd

Link to comment
Share on other sites

Well, Value List 2 is the value list attached to DropDown2 i.e. its simply your second list in a 2 field conditional value list system. All we are doing with the third list is adding an extra criteria. Assuming you know how to set up a basic conditional value list, this should make some sense if you logic it out, but i'll have a look at your sample in a sec.

Link to comment
Share on other sites

Hi Genx:

Lovely indeed. Do you think this could be applied in a City, State, Zip situation?

I have a ZipCode database that has all Cities, States and zipcodes included and would be great if I could type in the City and then click on State and get those related States and the get the proper zip or vice versa. Any ideas, suggestions?

Al

Link to comment
Share on other sites

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