When you create mandatory rules that compare table fields, the values in the fields are treated like alphanumeric fields.
To compare a table field that contains multiple values, the comparison statement must include the same text that’s displayed in the Maximizer interface, including all values for the field.
For example, the statement [Category] == "Partner" will be true only if the only value set in the Category field is "Partner". If the Category field includes the "Distributor" value as well, the rule would validate with the following statement: Category == "Distributor, Partner". You can use the Search function to locate text in multiple-value table fields.
To check that one of multiple values are set in a table field, use the OR operator in the rule. To check that two (or more) values are set in a table field, use the AND operator in the rule.
Example: Mandatory rule for table field using OR
The following rule validates if either the Distributor or Partner value is set in the Category field:
(Search(“Partner”,[Category]) > 0) OR (Search(“Distributor”,[Category]) > 0)
Example: Mandatory rule for table field using AND
The following rule validates if both "Distributor" and "Partner" are set in the Category field:
(Search(“Partner”,[Category]) > 0) AND (Search(“Distributor”,[Category]) > 0)