1 Reply Latest reply: Jun 25, 2012 5:55 PM by Jason Michaelides RSS

    Display issue for field 1 giving field 2 (one to one) but want to see multiple field 1 options based on field 2 (one to many)

      I am trying to get QV to work in the following way:

       

      User clicks on field ITEM

       

      Item then brings up field LABEL DIE

       

      (This part I can do, pretty easy with just standard objects.)

       

      Next, based on the item selection I would like to display all of the possible items that have the same LABEL DIE.  I have the info in a pivot table and ran a count in my expression.  I can view all of the LABEL DIE and also see a count of how many items are connected to the LABEL DIE.  I can even see the ITEM field until item is selected.  Is there a way to click ITEM and get all ITEMS listed with the same LABEL DIE?

       

      I have tried using set analysis, but can't get any code to work for it.  Thanks,

       

      Jason