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.
If I check the "Show values only from the second field, I get the screen below:
Any ideas where I'm going wrong?