Apologies in advance if you've seen these links before, but here are some links that set up the basics for conditional value lists.
Forum Tutorial: Custom Value List?
Knowledgebase article: http://help.filemaker.com/app/answers/detail/a_id/5833/kw/conditional%20value%20list
If that doesn't get your conditional value lists up and running for you, let me know and we'll dig deeper...
Thank you for the speedy reponse. What my problem is that I do not even know if I have done the value lists and relationships correctly. I took a look at what you recommended, but feel so lost because I think I udnerstand things, but it's not working.
so do my value lists and relationships look right.
I was also thinking: am I supposed to link everything on the tables together with AND?
You'll need to make some changes in order for this to work.
You'll need a category field in your order table that you can link it to the category field in File. Format this field with a value list of all the Category values from menu.
That makes this relationship possible:
Order::Category = File::Category
Now you can format Order::File with a value list of values from File, include only related values starting from "Orders".
Each such conditional value lists requires a relationship between a field in Orders and a field in the table of values instead of the "chain" of related tables you have here.
THANK YOU THANK YOU THANK YOU!!!