Creating a list that depend on a first choice...

[wdecock]

Hi,

 

I guess that my tag line is not that clear...lol... that's what beginners are all about..lol

 

I am looking for a way to influence the value list according to a certain value... i'll try to explain

 

Lets say i am creating a company restaurant and that i have everyday 8 different type of offers

 

I have created a library of recipes.

 

When i go to my weekly planning i find a table that looks much like an excel table with on top the 5 days of the week and on the side i have OFFRE1 to OFFRE8. When i select OFFRE1 i would have a list poping up so i can select if OFFRE1 is SOUP, STARTER,SANDWICH...etc. According to my selection i would like that if i select SOUP for exemple the entries i find for OFFRE1 under Monday to Friday show me only the SOUPS. I managed to do so if i predetermine that OFFRE1 will always be SOUP or STARTER... but i would like to leave the choice to the user to determine what the OFFRE1 would be...

 

I guess it is still 

 

HEEEEEEEEEEELP... that seems clear....lol

 

W

[wdecock]

I found the solutions and it seems to work.... 

[bcooney]

Just saw your post. What you want is called either a conditional value list, or a relational value list. See: http://help.filemaker.com/app/answers/detail/a_id/5833/~/creating-conditional-value-lists