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;
| T1 | T2 |
|---|
| Field1 | ID |
| Field2 | Name |
| 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.
| ID | Freq |
|---|
| 241646 | 0 |
| 321933 | 0 |
| 241644 | 0 |
| 241642 | 0 |
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.
| Name | Freq |
|---|
| 3PAR StoreServ Storage | 1 |
| EVA Storage | 1 |
| HP ProLiant DL Servers | 1 |
| Integrity Servers | 1 |
The frequency counts are much more than 1.
What am I missing? Is there an alternative method?
Thank you ,
John
