• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. Layout Enhancements > Working with Conditional Value Lists

Working with Conditional Value Lists

Value lists are an excellent tool in the battle against data errors, but they have some inherent limitations. The more possible entries you have, the less useful value lists become. FileMaker 5 enhances value lists by allowing you to use fields in your database to dynamically alter the value list display.

Imagine you're creating a database of store branches for a nationally franchised company. They have offices in major cities in each state. Although the number of cities is limited, it still averages 15 per state, and some of them have similar names with different spellings (like Charleston and Charlestown), making the entries difficult to validate. To solve this problem, you could begin by creating a file with two fields: the states and their cities. Using this file as a value list, you can create a relationship between the state and city fields of the store branches. When you enter a state, only its cities would appear as entry values.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint