Drop down menu related to previous field?

[ratiopharm]

Hello together,

I am pretty new to filemaker, however, it seems to be a convenient program. For my database, I have a question: Can I show different drop down menus in a field, based on what was entered in the previous field?

An example -)

Field1: Main dish

Field2: Topping

(Both fields are drop down menus).

If I choose "Pizza" in Field1, Field2 should show the values "Cheese" and "Peperoni" for selection.

If I choose "Pasta" in Field1, Field2 should allow to select either "Bolognese" or "Arrabiata".

Can this be accomplished in a simple approach, or is it very complicated? I plan the have 4 fields in row, each connected to the previous one (and it will not be about food -))

Thanks for suggestions!!!

Edited February 27, 2006 by Guest

[Lee Smith]

What you are describing is a conditional value list. Do a search of the Forum for [color:blue]+conditional +Value +List (be sure to include the pluses, ie.e enter just as I have posted) and it should return a bunch of information on how to do this.

Lee