I have a table of 14 records, each record has a field called description. I have a global field xyz in a second table. I create a layout using the second table. I put the global field xyz on the layout. I make it use a drop down list from the first table, field description. When clicking on the global field all I get are two descriptions. I'm missing the other 12. I tried everything. Any ideas?

As an additional comment, I also have a second field in the file called code. If, when I choose the dropdown, tell it to show a second field and pick code, then when I click on the field description + code shows up, and everone of them. If I go back and unclick show second field, only the two records descriptions show.