List Box Fequency either not showing or only showing 1
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;
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.
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.
3PAR StoreServ Storage
HP ProLiant DL Servers
The frequency counts are much more than 1.
What am I missing? Is there an alternative method?
Re: List Box Fequency either not showing or only showing 1
Frequency is not defined for the key fields. Field ID is a key field because it exists in both tables. If necessary, you can create copies of ID - ID1 in T1 and ID2 in T2 - and use ID1 and ID2 to find frequency.