Calculated Dropdown not showing all fields
Using option 1 from Custom Value List?, I've created a dropdown menu based on a calculated field.
The simplest example is Product Material - I want a calculated dropdown from the Supplies table to show all Supplies that have the category 'Material'.
I've used an IF calculation: If (Category="1";Supply Product Name;"")
Where the "1" category is a certain type of material.
Anybody know why I might only be getting a partial list of results?
All of the calculated results are showing up on the Supply Products table - but only about half of them are showing up in the dropdown list.