MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Distribution > Expert Configurator > Key Concepts and Procedures > Multiple Options Table

Multiple Options Table

 

The Expert Configurator has the capability to check multiple options for a specific occurrence of a value in a single statement.  This is done through the use of a multiple options table.  You can define many screen generated options to be members of a multiple options table.  You can then validate if any option in that table has a specific value.  It does not matter which option contains the value.  This eliminates the need to have a validation statement for each option.  Multiple options tables are defined in Reference File category Y12.

Example:

An option select screen may display the literal Ingredients followed by twenty blank lines to enter ingredients.  Each of the entry lines have an associated option name:  IN1, IN2, ... IN20.  For handling purposes, it is important to know if ACID was entered as an ingredient.  Rather than having twenty if statements, a single multiple option statement can be used.

A multiple options table named INGREDIENTS would contain the twenty values IN1, IN2, ... IN20.  The syntax to determine if ACID was entered as an ingredient would be as follows (assuming M is the variable code for multiple option table and EM is the operand for element of multiple option table):

("ACID", EM, M - INGREDIENTS)