3 Replies Latest reply: Sep 26, 2014 4:02 PM by John Cahill RSS

    List Box Fequency either not showing or only showing 1

    John Cahill

      Hello,

       

      I am trying to provide list box that uses either the ID field from my primary table or Name field from a reference table.

       

      The schema for the two table is very straight forward;

      T1T2
      Field1ID
      Field2Name
      Field3
      ID

       

      When I create a new list box and select ID, with frequency enabled, I get the ID displayed with a frequency of zero for each.

      IDFreq
      2416460
      321933 0
      2416440
      2416420

       

      My end goal is to provide the reference name along with the frequency count. Therefore I create a new list box with the Name field selected, with frequency enabled. However it only displays 1 for each. Most likely the reference table is not joined to the primary table in the list box object.

       

      NameFreq
      3PAR StoreServ Storage 1
      EVA Storage 1
      HP ProLiant DL Servers1
      Integrity Servers1

       

      The frequency counts are much more than 1.

       

      What am I missing? Is there an alternative method?

       

      Thank you ,

      John