I wanna have a special list when a field is selected.For example when in category list BURR is selected I wanna have a A B C in next list. and when the GRAVER is selected I wanna have some thing else.Would you please help me how to do it
There are a few ways to do this. Search for Conditional Value Lists or Cascading Value Lists.
Here is a good video from Soliant showing one way to get it done.
FileMaker Tip - Conditional Value List - YouTube
And here is a teaching file on conditional value lists that demonstrates a number of different ways that you might set up such a value list.
Adventures in FileMaking #1--conditional value lists
Each example comes with detailed documentation.
philmodjunk I am curious about the "do not use this" relationship set in your adventure file.
Why is it forbidden?
Each table occurrence group in the Adventure Files is documented with a text box, that typically identifies the specific example and article for which it is used.
Did you read the article to which that text note refers?
In helping others to set up a Hierarchical Conditional Value list prior to creating this file, a common error was to set up that particular table occurrence group. Changing the design to that used in this particular example was often the first step towards getting the CVLs to work. It's in the file so that I can do a screen capture and add to layout where this method is discussed to contrast it with the data model that does work for this example.
Retrieving data ...