Perhaps these links will help:
There's a lot of overlap between the first two links so you can read one and skim the other. The demo file gives you several examples of different conditional value lists so you can examine them to see how they are set up. If you are using FileMaker 12, you can open this demo file from your File menu to get a converted copy of the demo file that you can examine in FileMaker 12.
The last link discusses how to set up a chain of conditional value lists where the value selected in each conditional value list controls the values listed in the next value list.
Forum Tutorial: Custom Value List?
Knowledgebase article: http://help.filemaker.com/app/answers/detail/a_id/5833/kw/conditional%20value%20list
Hierarchical Conditional Value lists: Conditional Value List Question
Feel free to post follow up questions here if those links aren't enough to get your value lists working correctly.
Hi phil, thanks for the help ive tried this and again I'm going round in circles . please find enclosed.
what am i doing wrong, i can't get description to work, many thanks for your help.
ive placed another field called description in menu and also in order.
ive tried loads of different ways but i can't get the file to put in the description automatically after you have selected the item.
I have description as an edit field
i have also this in value lists
There are two ways to "look up" information from a related table. One method copies the data from the related record in to a field in the current record. The other method simply places the field from the related table on your layout. Both might work in this situation, which is best depends on what you need to do with the data.
This thread discusses both methods: Auto Fill