AnsweredAssumed Answered

Calculated Dropdown not showing all fields

Question asked by JamesTorr on Feb 9, 2012
Latest reply on Feb 10, 2012 by philmodjunk


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.