MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Distribution > Expert Configurator > Key Concepts and Procedures > Exhibit A: Expert Configurator Single-Level Example > Validating Configured Screens Through the Use of Tables

Validating Configured Screens Through the Use of Tables

 

By utilizing the ability of the Expert Configurator to manage values in tables, we can validate options with many possible valid values without creating a rule to check for each one.  Tables to be used by the configurator are defined on the Reference File category Y14.  We utilized tables in our example to validate that the color entered by the user is a valid color.  On category Y14 we entered the plant, table name, and table value associated with each color.  For every valid color, we create a new record on category Y14 with the same plant, table name as the previous records, but the table value (the color) changes each time.  See Common Features:  Reference File Categories for more information.  The figure below illustrates the entry of the color black into our DESKCOLOR table.

 

WILLIAMS                       COMMON FEATURES                         3/03/92

 DSP01                    REFERENCE FILE CATEGORY Y14           FUNCTION SELECT

                                                                                

                                                                               

                   Category Name           VALIDATION TABLES                   

                                                                               

                                                                               

                                        PLT(3)TABLE(9)VARIABLE(15)             

                   Category Key         BELDESKCOLORBLACK                       

                                        XXXXXXXXXXXXXXXXXXXXXXXXXXX            

                                                                               

                                                                               

                   Request Code         4                                      

                                                                               

                                        1 - Add                                

                                        2 - Change                             

                                        3 - Delete                             

                                        4 - Inquire                            

                                                                               

                                                                               

                                                                               

 F3=Exit             F7=End Category     F9=Inquiry          F8=Display List   

                                                                               

 

             Reference File Category Y14.

       This illustrates the entry of the color black into the DESKCOLOR table.

To validate the color entered on the sales order option select screen, we create a rule to check the entered option against our table.  The figure below illustrates the rule used to validate the color entered for the desk.

 

WILLIAMS   PLT BEL           EXPERT CONFIGURATOR                       3/03/92

 DSP01                   SALES ORDER RULE MAINTENANCE                    DETAIL

                               SCREEN VALIDATION                               

Rule Number     00110 01 Part Number      DESK-100        Action Code SV Vers 01

 Condition                                                                     

N(O-COLOR,EL,T-DESKCOLOR)                                                      

                                                                                

                                                                               

                                                                               

 ERROR MESSAGE                                                                 

INCORRECT DESK COLOR SELECTED                                                  

                                                                               

                                                                               

                                                                                

                                                                               

                                                                               

                                                                               

                                                                               

                                                                               

                                                                                

                                                                               

 F2=Command          F3=Exit             F7=Header           F9=Inquiry        

 F10=Function Select F15=Rekey Data                                            

              The Sales Order Rule Maintenance Detail Screen.

     This is the rule used to validate the color entered for desk DESKCOLOR.

The rule N(O-COLOR,EL,T-DESKCOLOR) means if the option value entered in the color field (O-COLOR) is not (N) an element (EL) of the table DESKCOLOR (T-DESKCOLOR), then display an error message.