i.e., Class (level 1)
Division (level 2)
Section (level 3)
Sub-Section (level 4)
Sub-Sub-Section (level 5)
You can set up a series of fields where the preceding drop down list filters the values listed in the next drop down list. Example:
Select Northern California in Field 1 and the value list in field 2 lists counties from from that region. Select a county in field 2 and the value list for field 3 lists cities from that county....
There are several ways to set that up and the ExecuteSQL function can be a useful way to get what's needed while keeping down the total number of table occurrences in your graph.
The following teaching file has working examples of SQL and nonSQL based hierarchical conditional value lists along with detailed documentation on how they were set up.
Adventures in FileMaking #1--conditional value lists
Retrieving data ...