AnsweredAssumed Answered

Value List based on another Table

Question asked by MikeWile on Mar 10, 2017
Latest reply on Mar 10, 2017 by 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?

Outcomes