Understanding Valid Intersections

Valid intersections are cell interactions that are filtered based on rules you define, called valid intersection rules, which filter certain cell intersections to users when they enter data or select runtime prompts. For example, you can specify that certain programs are valid only for some periods or departments. After valid intersections are defined, cells containing invalid data are read-only. This restriction speeds the planning process and optimizes the information available to users.

Conversely, you might have a use case where data entry is allowed in most cell combinations and you only need to prevent data entry to a select few cell combinations. In this case, you can ease the definition process by defining invalid intersections. You define invalid intersections in the same way that you define valid intersections except you can specify the invalid intersection definition type while creating the intersection group.

To better understand how valid intersections affect behavior in forms and in runtime prompts, see Working with Valid Intersections.