2 Replies Latest reply: Aug 22, 2012 4:56 AM by thomas.whitaker RSS

    Showing particular values in list box

      I would like a list box that only show certain values from a particular variabe.

       

      In this example tables 1 and 2 are linked by the item field. If I do a list box on item I get a list of items 1-8, I only want to show 1-4 (based on the "relevent" field in table 2). Is there an expression or am I missing something obvious (probably both)

       

      Table 1

      Item
      Item 1
      Item 2
      Item 3
      Item 4
      Item 5
      Item 6
      Item 7
      Item 8

      Table 2

       

      ItemRelevent
      Item 11
      Item 21
      Item 31
      Item 41