Dropdown selector: Sort ref column using a second column.

[shimodabt]

Hi, I am trying to sort values shown in a drop-down selector that contains ref values (ID Helix Prix). I want to sort these values using another column in the ref table (Tri).

When writing the ORDERBY function and selecting the proposed values by the editor when I start typing, I end up with an invalid code!

Any clue would be appreciated.

[Joseph_Seddik]

ORDERBY() requires key values, so your expression should be:

ORDERBY(A HELIX[ID Helix], [Tri])

[shimodabt]

Thanks, Joseph for taking the time!

[Joseph_Seddik]

Je t’en prie, bon courage !