List Box

[#1]

Good day,

I have loaded a table of
employees with 2 fields:  EmployeeID, and EmployeeName.

I have also loaded a transaction
table that also has EmployeeID (and can have multiple transactions for one
Employee Id) along with other data fields.

When I create a list box using
the Employee Name, I see all the Employee names and not just the ones that have
transaction records.

How can I have the List box only
show the Employee Names with transactions?

Thank you very much,

Mitch

[Clever_Anjos]

Something like

Aggr(Only({<TransactionFieldName={"*"}>}EmployeeName),EmployeeID)

[swuehl]

You can use an expression in the list box instead of just a field name (select <expression> from field drop down list on general tab of list box properties):

=Aggr( If(Count(TransactionID)>0,EmployeeName), EmployeeName)

or

=Aggr( Only({<EmployeeName = {"=count(TransactionID)>0"}>} EmployeeName), EmployeeName)

[#4]

Hi

I tried this and unfortunately it did not work.
I still see all the Employee names and not just the ones that have
transaction records.

[rwunderlich]

In the example given, the posters guessed at the name of a field in your transaction table. Can you post the expressoin you tried and confirm that it refers to a field that exists in your transaction table?

-Rob

[swuehl]

If you create a list box for field EmployeeName and a list box for a field from Transaction table, which should have a value in all records, like Transaction amount or TransactionID, and if you then right click on the transaction table field list box and 'Select all', are there any values in EmployeeName list box greyed out?