I want to set a constraint where quantity must not exceed 100, how do I do that?
Top  Previous  Next

Question:

I want to set a constraint where quantity must not exceed 100, how do I do that?

Answer:

In the EIP Template select the column tab and then the column in which you want to set the constraint. Make sure that a Class has been selected for the particularly column (see Column for details).

Now select the extra tab and in the options box and mark the required check box. This insures that this column has to contain a value. This is used later on when the Validation is set.

Next select the Action's tab and then the 'More Field Assignments' button to specify additional value assignments from the selected item's record. Press the Insert button to add a new assignment. If we presume that the column field is IND:Sell set the following entry field values:


constraint


So if the users enter a value larger than 100 the column value is reset to Null. Exit the column properties window and select the Validation tab. Mark the 'Validate when the control is Accepted' check box:


validatewhenthecontrolisaccepted


This prevents the user from continuing away from the column when the column value is Null.