Scenario 2

After reviewing the form designed by John in Scenario 1, Acme decides that they want Budget on the column instead of the row. To implement this requirement, John can move members within the axes to change the form layout. However, he does not need to update the data validation rules. John updates the form as shown in the following figure.

Form Layout at Design Time:

Form at Data Entry Time with Data Validations Applied:

For additional scenarios, see Data Validation Rule Scenarios.