It's called a conditional value list.
Maybe you need to do a search for that. Other people have explained it better then I could :)
If you can't find it I'd be happy to try and make you an example file.
SOme links on conditonal value lists that you might find helpful:
Forum Tutorial: Custom Value List?
Knowledgebase article: http://help.filemaker.com/app/answers/detail/a_id/5833/kw/conditional%20value%20list
I got it to work so now I see a conditional value list. But when I add more items to my table ie.
Steak, Chicken, Cole Slaw all for lunch the conditional value list is not updating. I had originally Steak and Chicken and I can see both these items when selecting lunch. But now I have added Hamburger, and Cole slaw but I don't see this updated
To what table did you add these items? Did you add them by adding records in the table from which you set your value list to draw the values? Did you also specify data in the field used in the relationship to filter the values?
If you answer yes to both questions, please spell out your exact value list setup, the relationship you've defined and exactly what you did to add those values.
I got it - I had relations correctly but I was specifying the wrong tables on the value list
Many Thanks Phil