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.