Get available values from field, based on current selections

[ledi12]

Hi.

I have a table with 4columns.

id, currency, company, customer

Company & customer can have only one currency.

It's possible that all selected companies & customers will have the same currency, so currency field will have only one value which is not greyed out.

I need this information for the condition in my expression. How can I solve it?

[Lisa_P · Accepted solution]

GetFieldSelections(currency)

if there are more than one, separate them with commas by GetFieldSelections(currency, ',')