Value list only displays 1st record is sorted by 2nd field
I'm having a perplexing issue with a value list. I'm using a table to draw the value list items from. I'm using zID for the first field value, and a category name field for the 2nd value. If I use the 2nd field to sort the list, only the first record in this table appears in my value list. This happens whether the "show only values from 2nd field" box is clicked or not. If I click to sort values by 1st field, it works normally.
I'm in FM10 Advanced here.