5 Replies Latest reply on Feb 10, 2012 9:05 AM by philmodjunk

    Calculated Dropdown not showing all fields



      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.