FirstSortedValue using parameters from 2 tables

[avigdova]

Hi, 

I get a null when trying to use the function in the following way:  FirstSortedValue (user_name, currentPerm).

while using 2 parameters from the same table, its working OK.

All the values of 'currentPerm' - the sort-weight are unique. 

Can anyone suggest a way to solve it?

[ogster1974 · Accepted solution]

can you not use UserCode instead of User_Name as appears in both tables?

[avigdova]

I could but i prefer to display the name.

Finaly I joined the 2 tables and the problem was solved. its not the best solution but its working.