1 Reply Latest reply: Mar 18, 2012 2:34 AM by Tresesco B RSS

    Help Please - Use Specific Value in Expression

      I have a list box with 3 items in it loaded from a table as so:

      'ListBox'

      Item1

      Item2

      Item3

       

      I would like to create an expression where I display dates that only correspond to one of the items in the list box.

      Straight Table currently displays the below regardless of item number selected:

      Item1   1/2/2012

      item2    2/2/2012

      item3    3/2/2012

      I only want to upon selecting item1 in my listbox to update the Straight Table to show only Item1 and associated date as listed below. How do i do this.

      Item1   1/2/2012

        • Re: Help Please - Use Specific Value in Expression
          Tresesco B

          Hello,  what you want is expected to happen automatically provided your data model is correct. therefore have a look at your model.

           

          script should be something like:

           

          Load

                 ITEM,

                 DATE,

                 ITEM & '  ' &DATE as ItemDate

          From .....table1;

           

          now for this table, if you select item1 under ITEM, your ItemDate list would show only "Item1 1/2/2012".

           

           

          Regards,  tresesco