AnsweredAssumed Answered

Value List Help

Question asked by art_l on Jan 5, 2015
Latest reply on Jan 5, 2015 by art_l


Value List Help



I have a situation where a value list function has changed from 2 choices, to 3 choices and I am looking for a simple elegant fix that requires minimal coding.  So far it illudes me.

The situation is as follows:

Choice 1: 1 Crossing Guard, 2 Street Corners

Choice 2: 2 Crossing Guards, 2 Street Corners.

The program under this situation has worked fine for years.  New parameter....

Choice 3: 1 Crossing Guard, 4 corners

The user typically picks 1 or 2 from a pull down menu and moves on.  A button is set up to prepare a sorted report on request returning values for 1 or for 2.  A new option was added to the search.... 3.  3 has to be included with 2.  In otherwords, all of the 2's now have to include all of the 3's if 3 is selected.  There has to be no change if 2 is selected, it has to return the 2's only, not the 3's.  1 remains unchanged.

See the attached screen shot.  I was hoping to add an OR operator to the equation, but doesn't seem to work as shown below (my first attempt to get it to add the 3...stopped here when it failed to return desired result).  Any suggestions greatly appreciated..... my skills with Value Lists is developing..... Thanks in advance.