11 Replies Latest reply on Dec 19, 2014 9:35 AM by deninger

    Value List from relationship

    deninger

      I have done this before, but for some reason I cannot get the following to work:

       

      1 table with four numerical columns and a fifth column as the text description Example:

       

      TO: GPIGroup (GPIGroup)

      Code: 01 Class: 00 SubClass: 00 Name: Penicillins

      Code: 01 Class: 10 SubClass: 00 Name: Penicillin G

      Code: 01 Class: 99 SubClass: 05 Name: Penicillin-Aminoglycoside Combinations

      ...

       

      Also created a "zero" column that is always = "00" and used this to create a reflexive relationship on Class and SubClass

      If I look at the relationship in a portal, it appears correctly as:

      TO: GPIGroupCode (GPIGroup)

      Code: 00 Name: Placebo

      Code: 01 Name: Penicillins

      Code: 02 Name: Cephalosporins

      ...

       

      This is the list I want to create for a popup in my interface.

       

      I have set it up like I always do:

      ValueList.jpg

       

      All I get is the dreaded <No Values Defined> in the popup

       

      All columns are indexed and devoid of any calculations, BTW

       

      Any help would be appreciated!