Interdependent Value Lists

by Matt Petrowsky

Article options

• Watch Preview Video
• Watch Full Version
• Download Technique File
• Download Movie File
• Cascading Value Lists Article
• User-based Value Lists

Back in October of 2012, I provided a video titled User-based Value Lists. Earlier in May of that same year, I presented Cascading Value Lists, which uses the new ExecuteSQL to generate the value list options. This video provides yet more information and another way of providing the same feature - plus many great tips along the way.

The method presented within this video does not use ExecuteSQL and may be easier to implement and manage if you're not quite ready for SQL.

As with most any software project, the goal is to provide the most power with the least amount of stuff (code) to manage. Any FileMaker solution can easily grow beyond it's maintainer's ability to understand every aspect of what they did before. If you consider a single master value list and one single script a powerful way of managing all value lists within the whole solution then you're in for a treat!