4 Replies Latest reply on Mar 10, 2017 8:12 AM by MikeWile

    Value List based on another Table

    MikeWile

      I am trying to create a drop-down list based on another table. I've done it quite a few times before but for some reason I can't get it to work in this solution. If I set it up as below, it works and displays a list of 75 names but that is not what I want. I want to show values only from the second field. The VENDOR::__pk_VendorID is a number field and the VENDOR::VendorName is a text field.

       

      Try1.png

      If I check the "Show values only from the second field, I get the screen below:

       

      Try2.png

      Any ideas where I'm going wrong?