If by "relates to" you mean that the values listed in field 2 are limited to only those appropriate for the value selected in field 1, you are describing a conditional value list. I have a large set of links that you can pick and choose from in order to learn more about how to set them up:
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 or later, you can open this demo file from your File menu to get a converted copy of the demo file that you can examine in your version of FileMaker.
The next to 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 and the very last link is a fairly new addition that describes how to use ExecuteSQL to produce conditional value lists that aren't easily possible with the other methods described here.
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
Using ExecuteSQL to produce a conditional value list: Using ExecuteSQL to Produce a Conditional Value List
Feel free to post follow up questions here if those links aren't enough to get your value lists working correctly.
Thanks Phil, but a bit confusing for a beginner like me.
Is it possible to do this in Conditional formatting from the second field. In the first field I have four values for types of courses available to select from, that is Discovering Buddhism, Basic Program, Masters Program and Anger Management. The second field for Discovering Buddhism I would need a drop down list showing the topics for Discovering Buddhism, I do have these as a value list, as with each type of course. Is there a formula I can use to bring in the correct drop down list when I select Discovering Buddhism from the first field.
I know you sent me a lot of info but I am not sure which one is relevant. I am good and following formulas and working out how do do something from this, if it is possible to give ma an example.
This cannot be done through conditional formatting.
All the links are relevant, but I'd start with either the first or second link and read it carefully. If you select the forum tutorial, ignore Option 1 as it won't be practical for this situation and concentrate on Option 2. (The knowledge base article only describes the "Option 2" method.)
Then, you can download and examine the demo file if you need to see actual conditional value lists so that you can open up manage | Value Lists, Manage | Database | Relationships and go to the different layouts and look at the data in the different tables to see working examples of how these are set up.
You don't need to look at the other threads unless you become interested in learning how to take these methods into more complex scenarios than what you have described here.
AWESOME Phil, thanks heaps again. I didn't use all the documentation, just followed the Demo file. I will definitely be keeping this for future reference.